Answer / naveed saleh

You can use this for getting nth highest salary from
Employee table as follows

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n > 1 (n is always greater than one)

Answer / anantkreshna v

select max(sal) from emp_table where sal < (select max(sal)
from emp_table);

Answer / mona thakur

SELECT *
FROM emp
WHERE salary < (
SELECT max( salary )
FROM emp )
ORDER BY salary DESC
LIMIT 1

Answer / kishor

select max(salary ) from employee
where
sal<(select max(salary)from employee)

Answer / vijay shegokar

select * from employee where salary=(select max(salary) from
employee where salary not in (select max(salary) from
employee));

Answer / vijay kintali

select e1.ename,e1.sal from emp e1 where n=(select count
(distinct e2.sal) from emp e2 where e1.sal<=e2.sal);

Note:n here is nth highest salary.......

Answer / arvind

select max(salary) from table_name where sal<(select
max(salary) from table_name)

Answer / bharat puri

select top 2 (salary) from emp
order by salary desc

Answer / gurvinder

select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);

Answer / sankar sasmal

select distinct sal from emp e where 2=(select count(distinct sal)from emp s where e.sal<=s.sal)

define join and explain different type of joins? : Sql dba

0 Answers  

what are all the common sql function? : Sql dba

0 Answers  

What is the current version of postgresql?

0 Answers  

What is the difference between alter trigger and drop trigger statements?

0 Answers  

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

What is db journal file?

0 Answers  

What operators deal with null?

0 Answers  

What is sql engine in oracle?

0 Answers  

how will you find out the last three records in a table with n no of records and delete them

3 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

What is a sql schema used for?

0 Answers