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

20 Answers
30088 Views
Infosys, Rolta, I also Faced
E-Mail Answers

Answer Posted / anil alpati

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

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rollback?

1187

How to download oracle sql developer?

1168

Is it possible to pass parameters to triggers?

1164

What is a design view?

978

What is data types in sql?

1070

What is a sql instance vs database?

1176

What is dialect in sql?

987

What is the syntax to add a record to a table?

1152

What are different types of triggers?

1186

What is posting?

1086

What is sql scripting?

1196

What are the different parts of a package?

1155

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1097

what is normalization? : Sql dba

1137

What are the types of queries in sql?

1130