Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / mk
SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER
BY SALARY DESC ) WHERE ROWNUM<6;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you identify a primary key?
what is difference between delete and truncate commands? : Sql dba
What are the different ddl commands in sql?
what does myisamchk do? : Sql dba
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is scalar function?
What does := mean in pl sql?
How can we find duplicate records in a table?
What is constant in pl sql?
What are the different types of constraints?
What is rollback?
Mention what plvcmt and plvrb does in pl/sql?
what is the difference between nested subquery and correlated subquery?
what is a materialized view? : Sql dba