Rank - Make ranking structure using SQL tool If we have collection of data and we want to make it an well structure by reduce duplication and make view based on ranking; we have a simple and easy option to do this operation.It is called Rank. For example we have data such like, Name Sales John 10 Jennifer 15 Stella 20 Sophia 40 Greg 50 Jeff 20 The general idea to display rank in SQL is to do a self-join , then list out the results in order, and finally do a count on the number of records that's listed ahead of (and including) the record of interest. So, we coming back to discussion. we have to make this data in ranking based order.so lets start with the query, SELECT a1.Name, a1.Sales, COUNT (a2.Sales) Sales_Rank FROM Total_Sales a1, Total_Sales a2 WHERE a1.Sales <= a2.Sales OR (a1.Sales=a2.Sales AND a1.Name = a2.Name) GROUP BY a1.Name, a1.Sales ORDER BY a1.Sales DES
I have got lots of knowledge from this blog thank you keep it up thanks for sharing your blog.
ReplyDeletetraining development software
Good Post. I like your blog. Thanks for Sharing
ReplyDeletePython Training in Noida
The above blog is super, I got clear idea about best Digital marketing course in Thrissur
ReplyDeleteThank for the information provided about search engine optimisation in thrissur .
ReplyDeleteThank you for this valuable information.Blog content was super IT courses in thrissur
ReplyDeleteIt was so interesting blog.Thank you for the information.
ReplyDeletebest coaching centre in Thrissur
Very good blog and article.I am very happy to visit your website.
ReplyDeleteweb development company in kerala
ecommerce website development
small business website design
best website designs in kerala
best web design company
digital marketing services
Thanks for sharing Valuable information.
ReplyDeleteExcellence Group Of Companies in Thrissur provides you better knowledge in Digital marketing. This will help you to be a professional in the digital marketing field. By joining in Excellence you can make a successful career in Digital Marketing. Be a Professional in SEO, SEM, SMM. Explore the new world of Digital Marketing.
thanks for the information. Excellence Group of Companies is also one of the best Digital Marketing Institute in Thrissur. They provide the course with 100% placement assistancy.
ReplyDeletethanks for the information. Excellence Group of Companies is also one of the best Digital Marketing Institute in Thrissur. They provide the course with 100% placement assistancy.
ReplyDeletethanks for the information. Excellence Group of Companies is also one of the best Digital Marketing Institute in Thrissur. They provide the course with 100% placement assistancy.
ReplyDeleteGreat post. Thank you for sharing
ReplyDeleteWEB DESIGN COMPANY INDIA
ReplyDeleteThanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts, have a nice weekend!
Software Testing Training Institute in Delhi- Because I'm Worth Career
Complete MS Office Training Course with Placement Assistance
Core to Advanced C & C++ Training Course with 100% Practical Information
Excel & Advanced Excel Training with 10+ Years’ Experience Trainer
Great Blog! I got too much information from this Blog. Thanks for sharing such a helpful Blog
ReplyDeleteExperience Certificate Providers in Bangalore- Exceedingly Good Career
Experience Certificate Providers in Hyderabad- Solutions for a Small Career
This is an outstanding post on this blog. I’m happy to see it here. It’s a very helpful and overwhelming little bit of details. Thanks for sharing useful information
ReplyDeleteAdvanced Excel Training, MIS & VBA Macros Training Institute
Certified Autodesk Training Institute in Delhi with Placement Support