smallest value

[chrisleon]

I have a database that has 52 rows with different values. If I wanted to grab the smallest and the largest number out of the database, without displaying the entire table, how would I do that. Pretty much a HI and LO.

any help would be appreciated.

[pete_bisby]

SELECT MAX(field) AS MaxField, MIN(field) AS MinField
FROM TABLE;

Then it's just a case of taking the values from the resulting row.