Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how to find nth highest salary

Answers were Sorted based on User's Feedback



how to find nth highest salary..

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

Is This Answer Correct ?    2 Yes 2 No

how to find nth highest salary..

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;

Is This Answer Correct ?    0 Yes 0 No

how to find nth highest salary..

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

Is This Answer Correct ?    2 Yes 2 No

how to find nth highest 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.

Is This Answer Correct ?    0 Yes 0 No

how to find 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)

Is This Answer Correct ?    0 Yes 0 No

how to find nth highest salary..

Answer / affu

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

Is This Answer Correct ?    1 Yes 1 No

how to find nth highest salary..

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;

Is This Answer Correct ?    1 Yes 1 No

how to find nth highest salary..

Answer / rabi

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

Is This Answer Correct ?    0 Yes 0 No

how to find nth highest salary..

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

Is This Answer Correct ?    1 Yes 1 No

how to find nth highest salary..

Answer / kiran k s

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

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,


Categories