SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / mk

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

Please Help Members By Posting Answers For Below Questions

What are the different types of database management systems?

1036

What is the primary use of normalization?

1053

What is oracle sql called?

974

What is the clause we need to add in function body to return variable?

1052

how to create a test table in your mysql server? : Sql dba

1056

What is bitemporal narrowing?

1370

What is equi join in sql?

1119

How do I quit sql?

1007

What are data types in pl sql?

1197

Why cross join is used?

1134

How many sql core licenses do I need?

994

What is the maximum size of sqlite database?

1155

What is the purpose of a secondary key?

1018

how to extract a unit value from a date and time? : Sql dba

1039

what is 'mysqlshow'? : Sql dba

1076