Answer / anonymous

select Max(salary) from test where salary not in(select Max
(salary) from test);

Answer / hemant

select salary,empname from employee where
salary=(select max(salary) from employee where
salary<(select max(salary) from employee))

This query will produce all the result whose salary is
second highest.

1. A 20000
2. B 20000
3. C 20000
4. D 20000

Answer / boring guy

select max(sal) from emp where sal!=(select max(sal) from
emp)

Answer / adithya

select min(sal) from (select distict sal from emp where
rownum<3 order by sal desc)

Answer / pankaj raj patel

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Answer / kasiraya

SELECT SALARY
FROM
(
SELECT ROW_NUMBER() OVER( ORDER BY SALARY DESC) AS
SL_NO,SALARY
FROM EMP
ORDER BY SALARY DESC
)
WHERE SL_NO=2

Answer / dinesh rajput

select sal from(select sal from
(select distinct sal from emp order by sal desc)
where rownum<=2 order by sal asc)
where rownum=1;

Answer / vinodkumar

select *from(select *from emp orderby sal desc)where
ronum<=2 minus select *from (select *from emp order by sal
desc ) where rownum<=1;

Answer / bell

SELECT TOP 1 FieldName FROM (SELECT TOP 2 FieldName FROM
Tabname ORDER BY FieldName DESC) allis ORDER BY FieldName
ASC

Answer / ramu

selectename,sal from (select ename,sal from emp order by sal
desc) where rownum<=5;

What are the types of join in sql?

0 Answers  

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

How can you load multi line records? : aql loader

0 Answers  

how to create a table index in mysql? : Sql dba

0 Answers  

Does sap use sql?

0 Answers  

What is compound trigger?

0 Answers  

How do u count no of rows in a table?

8 Answers   CTS,

How do I clear the screen in sql plus?

0 Answers  

Can you have more than one trigger on a table?

0 Answers  

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

what is a join? : Sql dba

0 Answers