SQLBank: SQL TOP

Pages

▼

Showing posts with label SQL TOP. Show all posts

Showing posts with label SQL TOP. Show all posts

Monday, September 28, 2020

TOP, LIMIT, ROWNUM vs DENSE_RANK

What would you do if you were asked to identify top-ten products based on their prices? In SQL Server, using a TOP clause with a specified n...

View web version

About Me

Shafi Shaik: Dubai, United Arab Emirates; Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.

View my complete profile

Powered by Blogger.