From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / sandeep
Select * from employee where rownum=1 order by sal desc
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you create a db file?
What is date functions?
What is embedded sql what are its advantages?
What are different types of tables in sql?
Does asenumerable execute the query?
How is sql used in oracle?
What is a unique key?
Differentiate pl/sql and sql?
How would you pass hints to the sql processor?
What is on delete restrict?
What is case function?
What are the different ddl commands in sql?
Which type of cursor is used to execute the dml statement?
What does fetching a cursor do?
What are few of the schema objects that are created using PL/SQL?