Breaking News: Grepper is joining You.com. Read the official announcement!

dense rank in mysql

Uninterested Unicorn answered on February 17, 2024 Popularity 9/10 Helpfulness 5/10

answer dense rank in mysql

dense rank in mysql

Comment

Customers table
+-------------+--------------+
| customer    | no_of_orders |
+-------------+--------------+
| Jake        | 200          |
| Amira       | 300          |
| Ben         | 200          |
| Rosa        | 500          |
+-------------+--------------+
select customer, no_of_orders, dense_rank() over(order by no_of_orders desc)
as topcustomers from Customers;
/*OUTPUT*/
+-------------+--------------+--------------+
| customer    | no_of_orders | topcustomers |
+-------------+--------------+--------------+
| Rosa        | 500          |       1      |
| Amira       | 300          |       2      | 
| Jake        | 200          |       3      |
| Ben         | 200          |       3      |
+-------------+--------------+--------------+

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: database dense-rank function mysql sql

Link to this answer
Share Copy Link

Contributed on Feb 17 2024

Uninterested Unicorn

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

dense rank in mysql

Contents

More Related Answers

dense rank in mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.