How do you find the maximum in a column?

[rajhoq12]

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

[delta_frost]

It is unclear what you wish to achieve by seeing the query you have posted.
To simply select max from a column/attribute
SELECT max(sal) FROM EMP //Displays maximum salary for the EMP table
It may be noted that group functions can't be used after the where clause
A second guess at what you are trying to achieve.
SELECT ename FROM emp WHERE sal = (SELECT max(sal) FROM emp) //Displays the ename having highest salary in the emp table.

[rishif2]

please make your post more clear

and explain you want to do?