select * from emp a where &n=(select count(distinct (sal)) from emp f

how to get second highest salary in SQL(as/4000

Question Posted / c srirammulu

Answer Posted / c srirammulu

select * from emp a where &n=(select count(distinct (sal))
from emp f where a.sal<f.sal)

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is user defined functions? : Sql dba

977

Explain what is table in a database?

1008

What is the basic form of sql query?

881

Give the order of sql select?

1089

How to fetch alternate records from a table?

1160

What is before trigger?

948

How do I quit sql?

899

how to calculate the difference between two dates? : Sql dba

995

How do we use distinct statement? What is its use?

977

Can we create index on primary key?

916

What is cross join example?

942

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3010

Write the command to remove all players named sachin from the players table.

1124

What is meant by cursor in sql?

942

What are the most important ddl statements in sql?

1027