Sequentially number rows by keyed group in SQL?

by

This covers most bases.

SELECT
    CODE,
    ROW_NUMBER() OVER (PARTITION BY CODE ORDER BY NAME) - 1 As C_NO,
    NAME
FROM
    MyTable

More Related Contents:

  1. Equivalent of Oracle’s RowID in SQL Server
  2. How do I use ROW_NUMBER()?
  3. How do I get a SQL row_number equivalent for a Spark RDD?
  4. Oracle ‘Partition By’ and ‘Row_Number’ keyword
  5. Sql Mathematical calculations [closed]
  6. I need help formatting inner join command in SQL query
  7. Search All Fields In All Tables For A Specific Value (Oracle)
  8. How to deal with SQL column names that look like SQL keywords?
  9. Generating a range of numbers in MySQL
  10. How to get next/previous record in MySQL?
  11. SQL best practice to deal with default sort order
  12. SQL transpose full table
  13. How to Create a real one-to-one relationship in SQL Server
  14. How does GROUP BY work?
  15. Linq version of SQL “IN” statement
  16. mysql, iterate through column names
  17. mySQL Returning the top 5 of each category
  18. Dynamic SQL to generate column names?
  19. Normalization in plain English
  20. postgresql generate sequence with no gap
  21. SQL Server PIVOT perhaps?
  22. Core Data Performance with Single Parent Entity
  23. How to find consecutive rows based on the value of a column?
  24. Custom aggregate function (concat) in SQL Server
  25. Find last day of a month in Hive
  26. Which SQL query is faster? Filter on Join criteria or Where clause?
  27. SQL Server *= Operator?
  28. Slow bulk insert for table with many indexes
  29. Convert date to YYYYMM format
  30. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it

Leave a Comment