select * from emp m where(select count(distinct sal)+1 from emp s where s.s

How to get second highest salary from a table

Question Posted / srinivas

Answer Posted / srinivas

select * from emp m where(select count(distinct sal)+1 from emp s where s.sal>m.sal)=2

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1243

how to get a list of all tables in a database? : Sql dba

1030

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1228

What is sql prepared statement?

1034

What does the file extension accdb stand for?

1015

What is the best free sql database?

1102

what is rollback? : Sql dba

1181

How many functions are there in sql?

1095

What is sql comments?

1119

How can you load multi line records? : aql loader

1125

What is primary key and unique key?

1167

How do you change a value in sql?

1066

What are secondary keys?

1030

What is the difference between pl and sql?

1153

What is write ahead logging in sql server?

1101