My Hell Boy

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

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