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);

Explain the properties of subqueries in sql server?

0 Answers  

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  

What is meant by indexing files?

0 Answers  

How to return the date part only from a sql server datetime datatype?

0 Answers  

How many categories of functions based their return modes?

0 Answers  

What is the difference between stored procedure and user defined functions?

0 Answers  

What is the difference between count and distinct count?

0 Answers  

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

Where the sql logs gets stored?

0 Answers  

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

What’s the distinction between dropping a info and taking a info offline?

0 Answers