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

What is sap sql anywhere?

974

tell me about various levels of constraint. : Sql dba

991

What are sql injection vulnerabilities?

911

How to move files from one directory to another in pl sql?

1130

Can we create index on primary key?

916

What is data manipulation language?

1137

Is primary key clustered or nonclustered?

954

What is trigger in sql?

1029

Does oracle use sql?

880

What is nosql vs sql?

1123

Why do we use partitions in sql?

979

What is varchar data type in sql?

1016

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1127

What are the set operators in sql?

1032

What is snowflake sql?

1012