SQL How to Select the most recent date item

sql oracle select date

Select * FROM test_table WHERE user_id = value AND date_added = (select max(date_added)    from test_table    where user_id = value)

sql oracle select date

Not sure of exact syntax (you use varchar2 type which means not SQL Server hence TOP) but you can use the LIMIT keyword for MySQL:

Select * FROM test_table WHERE user_id = value     ORDER BY DATE_ADDED DESC LIMIT 1

Or rownum in Oracle

 SELECT * FROM     (Select rownum as rnum, * FROM test_table WHERE user_id = value ORDER BY DATE_ADDED DESC) WHERE rnum = 1

If DB2, I'm not sure whether it's TOP, LIMIT or rownum...

sql oracle select date

With SQL Server try:

SELECT TOP 1 *FROM dbo.youTableWHERE user_id = 'userid'ORDER BY date_added desc

CodeHunter