Answer / sunil patel

with cte as (
SELECT DENSE_Rank() OVER(PARTITION BY ecc_dm_id_dep ORDER
BY ecc_gross_simple DESC) AS RowID,
*
FROM emp_curr_company
)
SELECT *
FROM cte
WHERE RowID = 2

Answer / jayakumar

please try this....

this is very usefull to you

select colunm_name from (select distinct(column_name) from
table_name where column_name is NOT NULL order by desc)
where rownum=n;

Answer / anand patel.

It is a very generic and easy way to find the Nth higest
salary with there employee/s name.

select * from emp where salary =
(select max(salary) from emp where salary in
(select top (select (count(*)-(n-1))from emp) salary
from emp order by salary))

Answer / satesh naidu

select * from emp e1 where &n=(select count(distinct
(e2.sal) from emp e2 where e.sal>e1.sal)

Hai friends try this.u will get nth highest salary.

Answer / guru

select max(salary) from Employee where salary not in(select
top (n-1) salary from Employee order by salary desc)

Answer / affu

select salary from table t where n-1=(select distinct count
(sal) from table t1 where t1.sal>t.sal)

Answer / aman kaushal

select salary from customer order by salary desc limit n,1;

here n is the array value 1st highest value starts with 0
value and then 1.

e.g

find the 2nd highest salary.

select salary from customer order by salary desc limit 1,1;

Answer / rabi

SELECT A.SAL
FROM TABLE A WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
WHERE A.SAL<=B.SAL);

Answer / kunal gupta

select top 1 sal from (select top n sal from tbl_master
group by sal order by sal desc)m order by sal

This answer is easiest and 100% tested

Answer / kiran k s

select distinct(salary) from table t1
where 4=(select count(distinct(salary))from table t2
where t2.salary >= t1.salary);

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

Can we add a cpu to sql server?

0 Answers  

What will you do If the low Performance occurs?

2 Answers  

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

how to define testing of network layers? : Sql server database administration

0 Answers  

What are the types of sql server?

0 Answers  

how to connect sybase to sql server 2005?.

1 Answers   ABC,

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

what is physical sort data and logical sort data in index?

2 Answers  

Explain different types of self contained sub query?

0 Answers  

What are the properties of the transaction?

0 Answers  

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,