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

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

Which are ddl commands?

0 Answers  

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

How to remove duplicate rows from table?

0 Answers  

How to turn off warning messages during php execution?

0 Answers  

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

What is temporal data type?

0 Answers  

What do you mean by a Composite primary key?

0 Answers   Genpact,

How many types of subqueries are there in sql server?

0 Answers  

What is change data capture (cdc) in sql server 2008?

0 Answers  

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers