select max(sal) from emp where sal not in(select max(sal) from emp where

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

Question Posted / kumar sumit

Answer Posted / kumar sumit

select max(sal) from emp where sal not in(select max(sal)
from emp where sal not in(select max(sal) from emp))

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is break?

1258

What is sql and also describe types of sql statements?

1114

How is indexing done in search engines?

1025

what is cursor. write example of it. What are the attributes of cursor.

1469

Write a sql query to get the third highest salary of an employee from employee_table?

1120

Can we use pl sql in sql server?

1136

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1227

What is bulk collect in pl sql?

1160

What are the different types of dbmss?

1060

what are string data types? : Sql dba

1093

explain advantages of innodb over myisam. : Sql dba

1178

What does the file extension accdb stand for?

1019

Why truncate is used in sql?

1045

What are types of indexes in sql?

1139

Why we use cross join?

1004