Select empsal From emp order by empsal desc offset 5 limit 1;

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / anil alpati

Answer Posted / anil alpati

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is log shipping? : Sql dba

1109

What is use of trigger?

929

how to concatenate two character strings? : Sql dba

1096

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3567

what is single byte over head in oracle..?

2398

How many functions are there in sql?

1012

What is the advantage of nosql?

1061

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3044

What are the key differences between SQL and PL SQL?

1211

what are the advantages of sql ? : Sql dba

1057

What is difference between nchar and nvarchar?

1024

What is bitemporal narrowing?

1305

what is the use of set statement in tsql? : Transact sql

1008

How to connect a sql*plus session to an oracle server?

1122

What is the least restrictive isolation level? : Transact sql

1063