How to return a incremental group number per group in SQL

by

you shouldn’t be using ROW_NUMBER(),

  • use DENSE_RANK() instead
  • remove PARTITION BY

query,

SELECT hl.ts_DateTime,  
       hl.Tagname as [ID],  
       hl.TagValue as [Value],
       DENSE_RANK() OVER (ORDER BY ts_datetime) AS RowFilter
FROM   Table1 hl 
ORDER  BY RowFilter

More Related Contents:

  1. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  2. How to group by a Calculated Field
  3. How to select all records from one table that do not exist in another table?
  4. SET versus SELECT when assigning variables?
  5. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  6. How do you list the primary key of a SQL Server table?
  7. Calculating distance between two points (Latitude, Longitude)
  8. Add Foreign Key relationship between two Databases
  9. SQL Server check case-sensitivity?
  10. Concat groups in SQL Server [duplicate]
  11. How to update Identity Column in SQL Server?
  12. How to assign an exec result to a sql variable?
  13. Concatenate values based on ID
  14. Query error with ambiguous column name in SQL
  15. Why (and how) to split column using master..spt_values?
  16. Splitting delimited values in a SQL column into multiple rows
  17. SQL: parse the first, middle and last name from a fullname field
  18. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  19. varbinary to string on SQL Server
  20. Scope of temporary tables in SQL Server
  21. SQL GROUP BY CASE statement with aggregate function
  22. SQL Server 2005 ROW_NUMBER() without ORDER BY
  23. Can an INNER JOIN offer better performance than EXISTS
  24. Find the real column name of an alias used in a view?
  25. Stored procedure that exports data into csv files only exports to one file
  26. Get Start and End Date from Week Number SQL Server
  27. How to get the identity of an inserted row?
  28. Get the last day of the month in SQL
  29. How to create a pivot query in sql server without aggregate function
  30. TSQL – How to use GO inside of a BEGIN .. END block?

Leave a Comment