get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)


select ename,Salary from Emp a group by Ename,Salary
   having 4=(select COUNT(distinct( salary) )from Emp b where a.salary<=b.Salary)

Comments

Post a Comment

Popular posts from this blog

iphone review

<iframe style="width:120px;height:240px;" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" src="//ws-in.amazon-adsystem.com/widgets/q?ServiceVersion=20070822&OneJS=1&Operation=GetAdHtml&MarketPlace=IN&source=ac&ref=tf_til&ad_type=product_link&tracking_id=cseindia-21&marketplace=amazon&region=IN&placement=B01NCN4ICO&asins=B01NCN4ICO&linkId=d39f0222a89bd1714f411d1b6fcc047a&show_border=false&link_opens_in_new_window=false&price_color=333333&title_color=0066c0&bg_color=ffffff">     </iframe>
Read more

Unable to add google gmail in iphone

Hello guys,                  i deleted my account and tried to add again but i was facing problem when i was entering my username and password then screen was flashing once then again go to choose option screen .  solution is you'll get micro second to save your setting . when you entered your details then screen will show save button upper right corner. then quickly press save button and you'll see your account has been added. thnx . hope it'll helpful.
Read more

How to find Nth highest salary in ms sql server

some guys confused how to write a query for getting output in sql server. there are so many way to get Nth salary .......... i am explaining two ways below find : select * from (select  Dense_Rank() over (order by salary  desc) as denserank,salary from SalaryMaster) as r where denserank= Value  Value=on which position rank you want i.e. 2 or 5th this is a Dense_Rank() function which gives you a sequence without skipping a number order. this is the best way to get Nth salary in a query. -------------------------------------------------------------------- 2nd way.  with CTE with CTESalary AS ( Dense_Rank() over (order by salary desc)as denserank, ,salary from SalaryMaster ) select * from CTESalary where denserank=2 
Read more