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

What is scalar and vector?

940

What is package in pl sql?

963

What is blind sql injection?

992

How to know the last executed procedure?

1035

Why is stored procedure faster than query?

909

Is sql scripting language?

975

How can I get the number of records affected by a stored procedure?

1003

What is dml with example?

1013

how do you login to mysql using unix shell? : Sql dba

1018

How do I remove duplicates in two columns?

977

Explain what is rdbms?

993

Explain some predefined exceptions.

992

Are subqueries better than joins?

922

What is set serveroutput on in pl sql?

1199

What is sql dialect?

1039