You write a query: SELECT ALL LName, FName FROM Personnel WHERE LName = ‘BROWN’ Why did you include the keyword ALL?

You write a query: SELECT ALL LName, FName FROM Personnel WHERE LName = ‘BROWN’ Why did you include the keyword ALL?

You write a query:
SELECT ALL LName, FName FROM Personnel WHERE LName = ‘BROWN’
Why did you include the keyword ALL?


Answer – You wanted every instance of Brown, not just the first one found.

(The ALL keyword is the default; DISTINCT is the option. DISTINCT returns only one combination of all select values specified.)