sql query distinct with Row_Number

by

This can be done very simple, you were pretty close already

SELECT distinct id, DENSE_RANK() OVER (ORDER BY  id) AS RowNum
FROM table
WHERE fid = 64

More Related Contents:

  1. How do I (or can I) SELECT DISTINCT on multiple columns?
  2. SQL/mysql – Select distinct/UNIQUE but return all columns?
  3. Is there any difference between GROUP BY and DISTINCT
  4. Group by minimum value in one field while selecting distinct rows
  5. How to use DISTINCT and ORDER BY in same SELECT statement?
  6. SQL to find the number of distinct values in a column
  7. Eliminating duplicate values based on only one column of the table
  8. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  9. Huge performance difference when using GROUP BY vs DISTINCT
  10. Produce DISTINCT values in STRING_AGG
  11. SQL distinct for 2 fields in a database
  12. How to select records without duplicate on just one field in SQL?
  13. Select distinct from multiple fields using sql
  14. SQL query with distinct and sum
  15. LIMIT 10..20 in SQL Server
  16. Alter a MySQL column to be AUTO_INCREMENT
  17. Delete column from SQLite table
  18. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  19. How to delete from select in MySQL?
  20. The new PIVOT function in BigQuery
  21. How to get the first and last date of the current year?
  22. Combine two tables for one output
  23. How to split string using delimiter char using T-SQL?
  24. Match only entire words with LIKE?
  25. PostgreSQL convert columns to rows? Transpose?
  26. SQL Inner join more than two tables
  27. What does ON [PRIMARY] mean?
  28. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  29. selecting top N rows for each group in a table
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment