Geeks With Blogs
Jim Lahman's Blog Fortitude|Endurance|Faith|Teamwork January 2011 Entries
Given a database table where multiple rows have the same values and only the most recent record is to be returned
I have a table where there are multiple records with the same value but varying creation dates. A sample of the database columns is shown here: 1: select lot_num, to_char(creation_dts,'DD-MO... HH24:MI:SS') as creation_date 2: from coil_setup 3: order by lot_num LOT_NUM CREATION_DATE ------------------------------ -------------------- 1435718.002 24-NOV-2010 11:45:54 1440026.002 17-NOV-2010 06:50:16 1440026.002 08-NOV-2010 23:28:24 1526564.002 01-DEC-2010 13:14:04 1526564.002 08-NOV-2010 22:39:01 ......

Posted On Monday, January 3, 2011 4:09 PM

Copyright © Jim Lahman | Powered by: GeeksWithBlogs.net