Answer / shruti

select empno,sal from
(select empno,sal from emp order by sal desc)
where rownum<4

Answer / tathagoto

select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);

Answer / sathiskumar

select min(sal) from (select top 3 salary from employee);

Answer / av.anil

SELECT * FROM
(SELECT Ename,Sal,
DENSE_RANK()
OVER(ORDER BY Sal DESC) "D_RK"
FROM Emp)
WHERE D_RK = 3;

This query gives exact highest salary.

Answer / jagdish

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

Answer / vivek

SELECT v.Emp_Sal
FROM Employee_Test v
WHERE 3=
(
SELECT COUNT(DISTINCT z.Emp_Sal)
FROM Employee_Test z
WHERE v.Emp_Sal<=z.Emp_Sal
)

Answer / shibin k abraham

select * from emp where sal=(select a.sal from emp awhere 3=(select distinct(count(b.sal)) from emp b where a.sal<=b.sal))

Answer / priyanga.g

1) Select MAX(salary) from Programmer where salary not
in(select top 2 salary from Programmer order by salary desc)



2) Select max(salary) from programmer where salary<
(select MAX(salary) from Programmer where salary<(select
MAX(salary) from Programmer))


3) Select MAX(salary) from Programmer e where 2=(select
COUNT(*) from programmer b where b.salary>e.salary )

Answer / ratnakar

select max(sal) from emp a where 3=(select count(sal) from
emp b where b.sal >=a.sal;

Answer / sheik

select top 1 * from(select top 3 *from emp order by salary
desc)d order by salary asc

What is the command used to fetch the first 5 characters of a string?

0 Answers  

What are all types of user defined functions?

0 Answers  

What are the dml statements?

0 Answers  

How to add, remove, modify users using sql?

0 Answers  

How collections are improve the performance?

1 Answers   Polaris,

Is sql injection illegal?

0 Answers  

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

What sql does db2 use?

0 Answers  

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

How to remove duplicate rows from a table?.

3 Answers  

What trigger means?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,