SQL Server: SELECT only the rows with MAX(DATE)

by

If rownumber() over(...) is available for you ….

select OrderNO,
       PartCode,
       Quantity
from (select OrderNO,
             PartCode,
             Quantity,
             row_number() over(partition by OrderNO order by DateEntered desc) as rn
      from YourTable) as T
where rn = 1

More Related Contents:

  1. The order of a SQL Select statement without Order By clause
  2. Select columns from result set of stored procedure
  3. What does “ORDER BY (SELECT NULL)” mean?
  4. SQL Server – join rows into comma separated list
  5. Taking the second last row with only one select in SQL Server?
  6. Subquery in select not working in SQL Server
  7. Storing images in SQL Server?
  8. How to create jobs in SQL Server Express edition
  9. Retrieve column definition for stored procedure result set
  10. Using varchar(MAX) vs TEXT on SQL Server
  11. SQL Server – Remove all non-printable ASCII characters
  12. Creating audit triggers in SQL Server
  13. TSQL Email Validation (without regex)
  14. Dynamic SQL results into temp table in SQL Stored procedure
  15. How to find the port for MS SQL Server 2008?
  16. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  17. TABLOCK vs TABLOCKX
  18. How to convert number of minutes to hh:mm format in TSQL?
  19. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  20. Dynamically assign filename to excel connection string
  21. Temporarily disable all foreign key constraints
  22. SQL Server Passthrough query as basis for a DAO recordset in Access
  23. T-SQL query to show table definition?
  24. Date range overlapping check constraint
  25. Conditional JOIN Statement SQL Server
  26. Is there an “IF EXISTS” test for a linked server?
  27. How do you deal with blank spaces in column names in SQL Server?
  28. Unique identifier (guid) as primary key in database design
  29. How to extract this specific substring in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment