select empno,sal from (select empno,sal from emp order by sal desc) whe

Find out the 3rd highest salary?

Question Posted / shruti

Answer Posted / shruti

select empno,sal from
(select empno,sal from emp order by sal desc)
where rownum<4

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is primary key a clustered index?

914

What is memory optimized table?

986

Is it possible to include an insert statement on the same table to which the trigger is assigned?

959

Can we use the cursor's to create the collection in PL/SQL?

961

Why is a primary key important?

968

What is faster join or subquery?

962

How many parts of a pl sql block are optional?

1035

How do you exit in sql?

1064

What is a full join?

912

What is delimiter in pl sql?

992

What is partition in sql query?

950

List the ways to get the count of records in a table?

853

Can we perform dml on view?

976

Can a varchar be a primary key?

955

What is dba in sql? : SQL DBA

999