Maximum Numerical Value in a Column

[Philosophaie]

How do you find the maximum in a column?

SELECT col2 FROM table1 WHERE col1=max(col1?);

[r937]

@Philosophaie

How do you find the maximum in a column?

SELECT col2 
  FROM table1 
 WHERE col1 = 
       ( SELECT MAX(col1)
           FROM table1 )