CASE n RANK Function in T-SQL
--CASESELECTSUM(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) sal4FROM HumanResources.EmployeePayHistory--RANKSELECT Rate,RANK() OVER (ORDER BY Rate DESC) AS RankBySalaryFROM HumanResources.EmployeePayHistory AS cmp ;
That's a Great Article and more useful for anyone.Thanks for sharing...
ReplyDeleteoracle course in chennai
Great Article blockchain projects for students
DeleteIEEE Projects for Engineering Students
JavaScript Training in Chennai
Networking Projects
JavaScript Training in Chennai
Great post I would like to thank you for the efforts you have made in writing this interesting and knowledgeable article. adult sex
ReplyDeleteThis implies you don't need to invest as much energy and cash either preparing existing staff, or employing engineers. Change Site URL Using MySQL
ReplyDeleteI 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. 事件・事故まとめ
ReplyDeleteI 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. 裁判判例と未解決事件データベース
ReplyDeletePretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon! dotcom secrets
ReplyDelete