Computer Science · Programming & Databases
A primary key must be:
ANullableBDuplicateCUnique and not nullDAuto-increment only
Why? A primary key uniquely identifies each row and cannot contain NULL.
Asked in: PPSC
Algorithms, data structures, SQL and web technology.
Why? A primary key uniquely identifies each row and cannot contain NULL.
Why? SELECT DISTINCT eliminates duplicate rows from the result set.
Why? The WHERE clause filters rows before grouping or ordering.