Suppose I have a table with attributes Name, Age as follows:
MyTable (Name, Age)
Now, to get the oldest age I can write the following query:
SELECT MAX(Age) AS "Oldest Age" FROM MyTable;
However, I cannot figure out the query in the case when I only want the name of the person with the oldest age. I tried the following, but it does not work:
SELECT Name FROM MyTable WHERE MAX(Age);
Any help appreciated.