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

What happens if you delete a table that is used by a view?

0 Answers  

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

What is 1nf 2nf?

0 Answers  

What is the use of MOVE keyword in restore command

3 Answers   IBM,

Describe in brief databases and sql server databases architecture.

0 Answers  

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

What do you understand by intent locks?

0 Answers  

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

What types of integrity are enforced by a foreign-key constraint

1 Answers  

where do you use Isolations?give me some exmpale?

1 Answers  

What is the difference between osql and query analyzer?

0 Answers  

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,