Nested Queries

[Amit Dilip Lonkar]

Hi!!

 I am trying to execute the following query. But it is giving an error at "select
max(columnname)....." 

select columname from tablename where columname1 = select max(columnname) from tablename 

Thanks 
Amit Lonkar