SELECT Rownum,emp-name,salary FROM(SELECT emp

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

Question Posted / priya

Answer Posted / priya

SELECT Rownum,emp-name,salary
FROM(SELECT emp_name,salary
FROM employees
ORDER BY salary Desc)
WHERE Rownum<=5;

Is This Answer Correct ?

17 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Does group by remove duplicates?

1122

Can we rollback truncate?

1086

what is collation? : Sql dba

1242

Is primary key clustered index?

1028

what is sql server agent? : Sql dba

1190

what are all the common sql function? : Sql dba

1143

what is schema? : Sql dba

1165

how to escape special characters in sql statements? : Sql dba

1124

define sql insert statement ? : Sql dba

1110

How do I remove duplicates in two columns?

1202

how to use regular expression in pattern match conditions? : Sql dba

1125

what is bcp? When does it used? : Sql dba

1065

What is the best sql course?

1064

how many tables will create when we create table, what are they? : Sql dba

1157

what are the advantages of sql ? : Sql dba

1154