SQL selection?

Question

I am having a brain-fart here.

How can I select the single highest number in a column?

ex: a table column has values 4,3,6,1,7,1,4 in it, I want to return ONLY the single highest value '7', how do I do that?

SELECT ???
FROM table
WHERE x = 'bla'

thanks ahead of time!

Answer 1

Depends on which version of SQL you are using. Microsoft SQL and MySQL handle this query differently.

Select TOP is one option.
Select MAX is another.

Answer 2

25

Answer 3

SELECT MAX(fieldname)
FROM table
WHERE conditional.