SQL: getting the max value of one column and the corresponding other columns [duplicate]

by

Use ROW_NUMBER() :

SELECT s.id,s.tag,s.version FROM (
    SELECT t.*,
           ROW_NUMBER() OVER(PARTITION BY t.id ORDER BY t.version DESC) as rnk
   FROM YourTable t) s
WHERE s.rnk = 1

More Related Contents:

  1. GROUP BY with MAX(DATE) [duplicate]
  2. Return row with the max value of one column per group [duplicate]
  3. Get top results for each group (in Oracle)
  4. Fetch the row which has the Max value for a column
  5. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  6. Fetch the rows which have the Max value for a column for each distinct value of another column
  7. Select latest row for each group from oracle
  8. SQL Query output in VBA is different than in SQL Oracle
  9. I want to find out how much zero come after 1 in SQL
  10. Select first row in each GROUP BY group?
  11. How to use the ‘as’ keyword to alias a table in Oracle?
  12. Stored Procedure with optional “WHERE” parameters
  13. subquery in FROM must have an alias
  14. SQL multiple columns in IN clause
  15. How can I select from list of values in Oracle
  16. Selecting the second row of a table using rownum
  17. sqlplus statement from command line
  18. Does Oracle store trailing zeroes for Number data type?
  19. Oracle Update Query using Join
  20. How to convert Rows to Columns in Oracle? [duplicate]
  21. Autoincrement in oracle to already created table
  22. SQL not displaying null values on a not equals query?
  23. What can cause an Oracle ROWID to change?
  24. How to add ‘ON DELETE CASCADE’ in ALTER TABLE statement
  25. Oracle query to match all values in the list among all rows in table
  26. Inserting into Oracle and retrieving the generated sequence ID
  27. How do I call an Oracle stored procedure from an Excel VBA script?
  28. Oracle DB: How can I write query ignoring case?
  29. Oracle Convert TIMESTAMP with Timezone to DATE
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment