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

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1004

what are ddl statements in mysql? : Sql dba

1202

what is schema? : Sql dba

1051

What are the rules to be applied to nulls whilst doing comparisons?

1324

How to select all records from the table?

1137

What is a natural join sql?

984

What is a boolean in sql?

985

What is fmtonly in sql?

1088

how to concatenate two character strings? : Sql dba

1104

How is a process of pl/sql compiled?

1161

Do we need commit after truncate?

1087

what is a control file ? : Sql dba

1045

Can we create table in function?

968

What is prepared statement in sql?

1056

What is varchar sql?

1150