Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / mohammad murtuza ali
select * from emp as(empname,empsal,empdesc) where rownum<6
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to display the current date in sql?
Explain autonomous transaction.
what are different types of collation sensitivity? : Sql dba
Explain cursor types?
Which data dictionary views have the information on the triggers that are available in the database?
What is execute immediate?
What is bind variable in pl sql?
How can you know that statistics should be updated?
how to show all tables with 'mysql'? : Sql dba
What are the different datatypes available in PL/SQL?
Explain ddl statements in pl/sql?
How many parts of a pl sql block are optional?
Define sql delete statement.
How do I get sql certification?
What is sql resultset?