Search results
4 lis 2010 · SELECT * FROM test_table T1 INNER JOIN (SELECT USER_ID, MAX(DOCUMENT_DATE) AS maxDate FROM test_table GROUP BY USER_ID) T2 ON T1.USER_ID = T2.USER_ID AND T1.DOCUMENT_DATE = T2.maxDate; It would be good to tell us what your RDBMS is though.
Here's one way to return only the most recent record for each user in SQL Server: WITH CTE AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY date DESC) AS rn FROM your_table ) SELECT * FROM CTE WHERE rn = 1;
select product_id, invoice_id, amount from mytable inner join myOtherTable on... inner join (select max(date) as last_date, product_id from mytable group by product_id) sub on mytable.date = sub.last_date
The `SELECT MAX(date)` statement is one of the most commonly used SQL queries. It allows you to quickly and easily find the latest date in a table or view. This can be useful for a variety of purposes, such as finding the most recent customer order, the oldest employee record, or the last time a website was updated.
2 sty 2017 · I have a table as below: SELECT [EffectiveDate] ,[Rate] [ModUser] FROM [Vision] there are many rows with the ModUsers name. I need to provide the ModUsers name and get the latest rates.
21 lis 2023 · Learn how to use the GREATEST() function to return the latest date from multiple date columns in SQL Server 2022. See an example query and the result table with the latest date highlighted.
13 sie 2024 · In this tutorial, we’ll explore various SQL techniques for retrieving data from the last N days, covering SQL Server, MySQL, and PostgreSQL, as well as different data types such as date and timestamp.
