Skip to content

Instantly share code, notes, and snippets.

@log4code

log4code/rownumber_mysql3.sql

Created April 13, 2019 20:20
Show Gist options
  • Save log4code/fcb5b7e90554935d74489aae15fc78e6 to your computer and use it in GitHub Desktop.
Save log4code/fcb5b7e90554935d74489aae15fc78e6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rownumber_mysql3.sql
SELECT
company_name,
sale_date,
total_amount,
@rank := IF( @comp_id = company_id, @rank + 1, 1) AS day_rank,
@comp_id := company_id AS company_id
FROM
company_sales
ORDER BY
company_id, total_amount DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment