Answer / venkates

select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)

Answer / nitin bisht

SELECT empSalary FROM empTable e1 WHERE (5 = (SELECT
COUNT(DISTINCT (e2.empSalary))
FROM empTable e2 WHERE e2.empSalary >= e1.empSalary))

Answer / skumar

Hi, friends This one is working fine. I have tested.

SELECT TOP 1 t.esal
from
(
select top 5 esal from employee order by esal desc
) t
order by t.esal asc

Answer / piyush gupta

select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)


you can this query for nth highest salary
replace 5 with any number

Answer / prasanna

select max(sal) from emp where sal not in (select Top 4 sal
from emp order by sal desc)

Answer / shahid

select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;

Answer / bhramar

select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal

Answer / suparna

select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)

Answer / chethan

select Salary from ( select salary from emp order by desc) as employee where rownum = 5;

Answer / bezalel

select salamt from
(
select rownum n,salamt from
(
select distinct salamt from emp order by salamt desc
)
)
where n=5

what is meant by Dynamic query?

3 Answers   Satyam,

if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media

1 Answers   Indian Web Technology,

What are the types of joins?

0 Answers   Tavant Technologies, Zensar,

can u combine pipeline parallelism and partition parallalism? how and whan?

0 Answers   TCS,

What is Stored procedure ?

4 Answers   IBM, iGate, Inspira Technologies,

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

0 Answers  

Write a query to retrieve for many to many relationships?

0 Answers   CGI,

How to shrink a database?

0 Answers  

how can we view column head in first page but not in remaining pages?

0 Answers   TCS,

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

0 Answers   Verizon,

Integrity constraints means..? how many and what are they?

4 Answers   AZTEC,

What is database and its types?

0 Answers