least and greatest

W

wxdqz

New Member
Hi,
I can't figure out how to use the functions least and greatest in queries.
For example, I have the following query :
"SELECT some_column FROM some_table WHERE another_column='something'"
How should I write my query to return the smallest and greatest some_column rows (using the functions least and greatest) from some_table?
Thanks in advance,
Emilien Arino
 
You must log in or register to reply here.
Back
Top