least and greatest

[[deleted]]

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

[lawnmowerman]

Why not try:
"SELECT min(some_column) AS least, max(some_column) AS greatest FROM some_table WHERE another_column='something'"

I'm not familiar with the least() and greatest() functions,
but from what I know, min() and max() should work on most (if not all) SQL servers.

I hope this helps!

-Rich

[[deleted]]

Thanks for your help!
It works just as expected 🙂
Emilien Arino

[[deleted]]

All of that was just two clicks away in the mySQL manual!