Aggregate SQL Function to grab only the first from each group

by

Rather than grouping, go about it like this…

select
    *

from account a

join (
    select 
        account_id, 
        row_number() over (order by account_id, id) - 
            rank() over (order by account_id) as row_num from user
     ) first on first.account_id = a.id and first.row_num = 0

More Related Contents:

  1. Retrieving last record in each group from database – SQL Server 2005/2008
  2. Base64 encoding in SQL Server 2005 T-SQL
  3. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  4. How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
  5. Calculating timespan with t-sql
  6. Isoweek in SQL Server 2005
  7. Is it possible to write single query on two table which are not connected to each other?
  8. SQL update query using joins
  9. How to update two tables in one statement in SQL Server 2005?
  10. SQL query to select dates between two dates
  11. Create a date from day month and year with T-SQL
  12. Integer division in sql server
  13. How to get Time from DateTime format in SQL?
  14. Selecting COUNT(*) with DISTINCT
  15. How much size “Null” value takes in SQL Server
  16. SQL – Subtracting a depleting value from rows
  17. SELECT FOR UPDATE with SQL Server
  18. Easiest way to populate a temp table with dates between and including 2 date parameters
  19. How do I move files to an archive folder after the files have been processed?
  20. WHERE clause on SQL Server “Text” data type
  21. SQL Server error on update command – “A severe error occurred on the current command”
  22. subquery or leftjoin with group by which one is faster?
  23. Foreign key relationship with composite primary keys in SQL Server 2005
  24. Unique Key Violation in SQL Server – Is it safe to assume Error 2627?
  25. SQL server schema and default schema
  26. How to recover deleted rows from SQL server table?
  27. OPENXML with xmlns:dt
  28. FOR XML PATH(”): Escaping “special” characters
  29. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  30. Multiple Select Statements using SQL Server 2005 “WITH” Statement

Leave a Comment