SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT(2,1)

how to check the 3rd max salary from an employee table?

Question Posted / neeraj79

Answer Posted / neeraj79

SELECT DISTINCT salary
FROM employee
ORDER BY salary DESC
LIMIT(2,1)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Where is sql database stored?

921

Which type of cursor is used to execute the dml statement?

896

How do I start pl sql?

899

How can you save or place your msg in a table?

954

What is difference between db2 and sql?

940

Is sql better than excel?

1062

What is an example of translating a date into julian format?

1042

What is the difference between instead of trigger and after trigger?

949

What is sqlerrm?

883

What is cross join sql?

868

How to assign sql query results to pl sql variables?

995

How can a function retun more than one value in oracle with proper example?

1029

what are the differences between char and nchar? : Sql dba

1056

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

951

Which is better cte or subquery?

970