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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2002-12-20 : 03:57:33
|
| ID_A ID_B ID_C Date Desc------------------------------------------------------------------- 1 103115 1 2002-07-04 PHINISI DANA KAS1 103115 1 2002-07-25 PHINISI DANA KAS1 103115 1 2002-07-25 PHINISI DANA KAS1 103115 1 2002-11-22 PHINISI DANA KAS1 103115 1 2002-11-28 PHINISI DANA KAS1 103115 1 2002-11-28 PHINISI DANA KAS19 103115 1 2002-03-27 COMMONWEALTH DANA PREMIUM19 103115 1 2002-04-25 COMMONWEALTH DANA PREMIUM19 103115 1 2002-05-08 COMMONWEALTH DANA PREMIUM19 103115 1 2002-05-13 COMMONWEALTH DANA PREMIUM19 103115 1 2002-05-24 COMMONWEALTH DANA PREMIUM20 103115 1 2002-07-25 SCHRODER DANA MANTAP PLUS20 103115 1 2002-07-25 SCHRODER DANA MANTAP PLUS20 103115 1 2002-07-26 SCHRODER DANA MANTAP PLUS20 103115 1 2002-07-26 SCHRODER DANA MANTAP PLUS23 103115 1 2002-11-12 ABN AMRO DANA KAS RUPIAH23 103115 1 2002-11-12 ABN AMRO DANA KAS RUPIAHhow to make result like that but the ID_A is no duplicateoh |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-20 : 04:08:53
|
quote:
ID_A ID_B ID_C Date Desc------------------------------------------------------------------- 1 103115 1 2002-07-04 PHINISI DANA KAS1 103115 1 2002-07-25 PHINISI DANA KAS1 103115 1 2002-07-25 PHINISI DANA KAS1 103115 1 2002-11-22 PHINISI DANA KAS1 103115 1 2002-11-28 PHINISI DANA KAS1 103115 1 2002-11-28 PHINISI DANA KAS19 103115 1 2002-03-27 COMMONWEALTH DANA PREMIUM19 103115 1 2002-04-25 COMMONWEALTH DANA PREMIUM19 103115 1 2002-05-08 COMMONWEALTH DANA PREMIUM19 103115 1 2002-05-13 COMMONWEALTH DANA PREMIUM19 103115 1 2002-05-24 COMMONWEALTH DANA PREMIUM20 103115 1 2002-07-25 SCHRODER DANA MANTAP PLUS20 103115 1 2002-07-25 SCHRODER DANA MANTAP PLUS20 103115 1 2002-07-26 SCHRODER DANA MANTAP PLUS20 103115 1 2002-07-26 SCHRODER DANA MANTAP PLUS23 103115 1 2002-11-12 ABN AMRO DANA KAS RUPIAH23 103115 1 2002-11-12 ABN AMRO DANA KAS RUPIAHhow to make result like that but the ID_A is no duplicateoh
Can you please elaborate more and post the query?Expect the UnExpected |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-20 : 04:21:27
|
| ????maybeselect *from tblwhere Date = (select min Date from tbl t2 where t2.ID_A = tbl.ID_A)==========================================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. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2002-12-20 : 09:29:06
|
| Decide which of the dates, which appear to be the only fields that change, you want to return, if any. for example, do you want the lowest (MIN) or the highest (MAX) for each group?Then you can say:SELECTID_A, ID_B, ID_C, MIN(Date) as MinDate, Desc FROM TableGROUP BY ID_A, ID_B, ID_C, Desctake away fields from the GROUP BY and add MIN's or MAX's to the SELECT part as needed.- Jeff |
|
|
|
|
|
|
|
|
Select distinct