selectename,sal from (select ename,sal from emp order by sal desc) where r

how to find the second highest salary from emp table?

Question Posted / ramu

Answer Posted / ramu

selectename,sal from (select ename,sal from emp order by sal
desc) where rownum<=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I enable sql encryption?

1028

What is use of term?

1062

Is ms sql traffic encrypted?

922

what is the difference between delete and truncate commands? : Sql dba

1068

how to check myisam tables for errors? : Sql dba

1321

What is pl sql architecture?

957

Is join an inner join?

963

Can variables be used in sql statements?

1030

Is sql database free?

971

Do foreign keys improve performance?

1022

how to create a new table by selecting rows from another table in mysql? : Sql dba

1087

What is scalar data type in pl sql?

1066

What is difference between stored procedure and trigger?

1165

Which is better join or inner query?

1043

Define the select into statement.

1050