Select * from employee where rownum=1 order by sal desc

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / sandeep

Answer Posted / sandeep

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql performance tuning?

868

what are the type of locks ? : Sql dba

901

What is multiple columns?

1002

how to create a new view in mysql? : Sql dba

895

what are the different tables present in mysql? : Sql dba

925

What is cold data?

898

Can we use join in subquery?

1023

What is the command used to fetch first 5 characters of the string?

1336

What is embedded sql in db2?

962

How do you rename a table in sql?

1034

What is difference between my sql and sql?

997

What is difference between rank () row_number () and dense_rank () in sql?

1052

What is time based sql injection?

904

how to write date and time literals? : Sql dba

915

What are the disadvantages of file system?

1165