Wednesday, July 27, 2016

CASE n RANK Function in T-SQL

CASE n RANK Function in T-SQL


--CASE
SELECT
     SUM(CASE WHEN Rate>0 AND Rate<10 THEN 1 ELSE NULL END) sal1,
SUM(CASE WHEN Rate>10 AND Rate<20 THEN 1 ELSE NULL END) sal2,
SUM(CASE WHEN Rate>20 AND Rate<100 THEN 1 ELSE NULL END) sal3,      
SUM(CASE WHEN Rate>100 AND Rate<10000 THEN 1 ELSE NULL END) sal4 
  FROM HumanResources.EmployeePayHistory


--RANK
SELECT  Rate,   
       RANK() OVER (ORDER BY Rate DESC) AS RankBySalary  
FROM HumanResources.EmployeePayHistory AS cmp ; 

5 comments:

  1. That's a Great Article and more useful for anyone.Thanks for sharing...
    oracle course in chennai

    ReplyDelete
  2. Great post I would like to thank you for the efforts you have made in writing this interesting and knowledgeable article. adult sex

    ReplyDelete
  3. This implies you don't need to invest as much energy and cash either preparing existing staff, or employing engineers. Change Site URL Using MySQL

    ReplyDelete
  4. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. 事件・事故まとめ

    ReplyDelete
  5. I was surfing net and fortunately came across this site and found very interesting stuff here. Its really fun to read. I enjoyed a lot. Thanks for sharing this wonderful information. 裁判判例と未解決事件データベース

    ReplyDelete