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 |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2001-09-21 : 04:37:33
|
| Hi,I am having situation like this :I have a table with the following....Code,amt,date001,100,2001/01/01001,200,2002/01/01002,200,2001/01/01And I needs the result like thisCode,amt,date001,300,2001/01/01002,200,2001/01/01I wants to say that I need the first code and the first date from multiple matching codes and also need the sum of amt field for the matching codes only.Any guidelines invited.... |
|
|
|
|
|
Query Needed