Answer / velmurugan p

Select min(sal) from table_name where sal in(Select top 2 sal from table_name)

Answer / karthik.k

select max(salary) as second_highest from emp where salary
< (select max(salary) from emp)

Answer / pramod sharma

select f_name max(salary)from emp,dep
where salary<(select max(salary)from emp)

Answer / satish kumar

Select Top1 salary
from(select Distinct Top2 salary from employee order by salary DESC) a order by salary

Answer / rajkumar

SELECT * FROM TABLE WHERE columnName =
(SELECT MAX(column_name) FROM TABLE WHERE
column_name<(SELECT max(column_name) FROM TABLE))

Answer / mangesh pardhi

SELECT salary
FROM employee e
WHERE 2=(SELECT COUNT(DISTINCT salary)
FROM employees
WHERE e.salary<=salary)
--replace the number with 2,3,4 u wil find the that position
salary

Answer / kishan singh chilwal

SELECT MAX(sal)
FROM emp
WHERE sal <> (SELECT MAX(sal) FROM emp);

<> = not equal to
the SELECT statement in the WHERE clause will find the 1st max sal in the table
the 1st SELECT statement will find max sal in the table after excluding the first max sal

(ALTERNATE WAY)

SELECT MAX(sal)
FROM emp
WHERE sal not in (select max(sal) from emp );

Answer / syed hussain

select min(salary) from tbl_emp where salary in
(select top 4 salary from Tbl_emp order by salary desc)

Answer / hima

select sal from emp order by salary desc limit 1,1

Answer / subahar

SELECT MAX(average) AS Expr1
FROM sp
WHERE (average NOT IN
(SELECT MAX(average) AS Expr1
FROM sp AS sp_1))

What is integrity constraints?

5 Answers   Ramco, Satyam,

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

what is a view? : Sql dba

0 Answers  

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

What is java sql drivermanager?

0 Answers  

What is a field in a database?

0 Answers  

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

Why do we need cursor in pl sql?

0 Answers  

Is sql a oracle?

0 Answers  

What is parallel hint?

0 Answers  

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

What does plv msg allows you to do?

0 Answers