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

how to use regular expression in pattern match conditions? : Sql dba

966

What is the use of index in sql?

961

how to extract a unit value from a date and time? : Sql dba

948

How to place comments in pl/sql?

1099

What are the different types of sql commands?

1065

Does user triggers have entry for trigger with compilation errors?

975

how can we optimize or increase the speed of a mysql select query? : Sql dba

890

What is delete command in sql?

1053

what are dynamic queries in t-sql? : Transact sql

963

Why do we go for stored procedures?

995

What is parameter substitution in sql?

977

What are system versioned tables?

969

Explain the advantages and disadvantages of stored procedure?

1077

How do I run a program in pl sql?

952

What is varchar sql?

1060