Answer / vinod

SELECT MAX(SAL) FROM TEST_123 WHERE SAL NOT IN (SELECT
MAX(SAL) FROM TEST_123)

Answer / udayalakshmij

select emp_name,max(salary) from emp except(select max(salary) from emp);

Answer / amarendra swain

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

Answer / shankar panda

SELECT DISTINCT(E.SALARY) FROM EMPLOYEES E WHERE 2=(SELECT COUNT(DISTINCT D.SALARY) FROM EMPLOYEE D WHERE D.SALARY >= E.SALARY)

Answer / sreenadh reddy

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

Answer / bharath konegadde

Select Emp_Name from emp_table where Id=(Select Emp_Id from Salary Order By salary Desc limit 0,1)

Answer / chiguru&

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)

Answer / mohan rathour

select max(e1.salary) from Emp_table e1 where e1.salary not
in (select max(e2.salary) from Emp_table e2 )

Answer / harish

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

Answer / manikishore

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


//if you want to retrieve 3rd max(sal) then you can use 3 in place of 2,,,like that for so on..

Is sql an operating system?

0 Answers  

Why do we use partitions in sql?

0 Answers  

What is the difference between join and union.

27 Answers   3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,

How many triggers can be implemented for a table?

3 Answers   HSBC,

What is cursor status?

0 Answers  

which will fire first ? Trigger or Constraint

24 Answers   i2, IBM,

Is oracle and sql same?

0 Answers  

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

What are actual parameters and formal parameters?

0 Answers  

What does := mean in pl sql?

0 Answers  

tell us something about heap tables. : Sql dba

0 Answers