SELECT MAX(column_name) FROM table_name

Oct 17 2012 4:13 AM

This question was asked in the interview(MCQs).Just wanted to confirm from you guys.
I selected option b.
a) It will return the birthdate of eldest person
b) It will return the birthdate of the elder person among those whose birthdates are mentioned

"appropriate" answer : ?

Answers (2)

Sub-queries in SQL

@@error and @@rowcount in SQL