select DISTINCT(salary) from emp order by salary desc limit 1,1 this lim

how to find the second highest salary from emp table?

Question Posted / chirag shah

Answer Posted / chirag shah

select DISTINCT(salary) from emp order by salary desc limit 1,1

this limit gives you 2nd record
if you want 3rd value then write limit 3,1

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does google use sql?

950

What are inner outer left and right joins in sql?

1009

Explain what is rdbms?

1027

What is cartesian join in sql?

1114

what is a join? : Sql dba

1027

What is assignment operator in pl sql?

1029

Are subqueries better than joins?

970

What is trigger in sql?

1087

What is a record in pl/sql?

1140

What is rollback?

1110

What can I use instead of union in sql?

963

what are the different type of normalization? : Sql dba

1025

What are functions in sql?

953

How do you change a value in sql?

1011

What is sql comments?

1072