Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bharatsql
Starting Member
22 Posts |
 Posted - 2005-03-21 : 11:02:48
|
| Hi,I'm trying to build a query (SQL) where in I need to pick the latest updated record for each record. Following is the DDL for the table, I'm using:CREATE TABLE DB2DBA.SL_PRODUCT_GROUP ( SL_PRODUCT_GROUP_ID INTEGER NOT NULL, POPULATION_INFO_ID INTEGER NOT NULL, PRODUCT_NAME VARCHAR(50) NOT NULL, PRODUCT_GROUP VARCHAR(50) NOT NULL, SOURCE_CREATION_TS TIMESTAMP NOT NULL, SOURCE_LAST_MODIFIED_TS TIMESTAMP NOT NULL, CREATION_TS TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP, LAST_MODIFIED_TS TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP)I basically need is to pick the latest record for any given product_name. Pls. let me know what shall be the sql.Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-21 : 12:15:02
|
| select *from DB2DBA.SL_PRODUCT_GROUP twhere t.LAST_MODIFIED_TS = (select max(t2.LAST_MODIFIED_TS) from DB2DBA.SL_PRODUCT_GROUP t2 where t.PRODUCT_NAME = t2.PRODUCT_NAME)==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bharatsql
Starting Member
22 Posts |
Posted - 2005-03-21 : 13:11:49
|
| Thanks it worked!!! |
|
|
|
|
|
|
Select max value for each record.