SQL query to get most recent row for each instance of a given key

by

Try this:

Select u.[username]
      ,u.[ip]
      ,q.[time_stamp]
From [users] As u
Inner Join (
    Select [username]
          ,max(time_stamp) as [time_stamp]
    From [users]
    Group By [username]) As [q]
On u.username = q.username
And u.time_stamp = q.time_stamp

More Related Contents:

  1. Select first row in each GROUP BY group?
  2. Optimize GROUP BY query to retrieve latest row per user
  3. How to select id with max date group by category in PostgreSQL?
  4. Optimize groupwise maximum query
  5. Get values from first and last row per group
  6. Get most common value for each value of another column in SQL
  7. PostgreSQL: top n entries per item in same table
  8. Conditional lead/lag function PostgreSQL?
  9. Refactor a PL/pgSQL function to return the output of various SELECT queries
  10. Query for array elements inside JSON type
  11. Calculating Cumulative Sum in PostgreSQL
  12. What is the expected behaviour for multiple set-returning functions in SELECT clause?
  13. Is it possible to make a recursive SQL query?
  14. SQL: Find the max record per group [duplicate]
  15. Fetch the rows which have the Max value for a column for each distinct value of another column
  16. Way to try multiple SELECTs till a result is available?
  17. Column ‘mary’ does not exist
  18. Get top row(s) with highest value, with ties
  19. Delete parent if it’s not referenced by any other child
  20. PostgreSQL wildcard LIKE for any of a list of words
  21. Query that ignore the spaces
  22. Postgres – Function to return the intersection of 2 ARRAYs?
  23. How to store array or multiple values in one column
  24. convert Postgres geometry format to WKT
  25. COPY with dynamic file name
  26. Table or column name cannot start with numeric?
  27. PostgreSQL column ‘foo’ does not exist
  28. Return rows from INSERT with ON CONFLICT without needing to update
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. Fetch records that are non zero after the decimal point in PostgreSQL

Leave a Comment