in
Questions and answers to issues related to Software: Business, Database, Firewalls, Office, Graphics, Security, System, Server. » Database » Oracle » SQL command to find the highest / lowest value ?

SQL command to find the highest / lowest value ?


Hello,

What is best SQL command to find the highest or lowest values of a column in a table ?

Should one be using ORDER BY and ORDER BY  DESC; commands or are there better ones ?

Solution: SQL command to find the highest / lowest value ?

If the above doesn't work, try this...

SELECT * FROM MyTable WHERE Col = (SELECT Max(Col) from MyTable);

Popular Tags

Browse All Tags