SELECT TOP 1 * FROM [SELECT TOP 3 * FROM Emp_Salary ORDER BY Salary DESC;]

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

Question Posted / neeraj

Answer Posted / neeraj

SELECT TOP 1 * FROM [SELECT TOP 3 * FROM Emp_Salary
ORDER BY Salary DESC;]
ORDER BY Salary;

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Where the sql database files are stored?

1026

Explain the types of joins in sql?

1038

what is the difference between $message and $$message? : Sql dba

1006

What is an implicit commit?

1061

What is normalization? How many normalization forms are there?

1092

Explain what is an index?

1066

what is a composite primary key ? : Sql dba

1059

What is not null in sql?

1062

What is the use of prepared statement?

1034

Can you load data into multiple tables at once? : aql loader

1078

What is a constraint? Tell me about its various levels.

1168

What is composite data type in pl sql?

1123

What is out parameter used for eventhough return statement can also be used in pl/sql?

1089

What does subquery mean in sql?

1061

When are we going to use truncate and delete?

996