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))

Which nosql database is best?

0 Answers  

What do you think about pl/sql?

0 Answers  

What is a sql driver?

0 Answers  

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

what is the bond code in materialized view?

0 Answers  

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

How do I edit a stored procedure?

0 Answers  

What are different categories of sql commands?

0 Answers  

What is the location of pre_defined_functions.

0 Answers  

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

What is the maximum size of sqlite database?

0 Answers  

what is timestamp in mysql? : Sql dba

0 Answers