Grouping by a selected fiels

[Jhankins]

I have the following data:

id date amount chequeid transid
1 22/05/04 10 1 001
1 22/05/04 15 1 002
1 22/05/04 30 2 003
1 23/05/04 40 3 004

I want to return 3 columns i.e. group all the chequeid that are the same so it will return then following

id date amount chequeid transid
1 22/05/04 25 1 002
1 22/05/04 30 2 003
1 23/05/04 40 3 004

Any idea's??

Thanks

 

[aolb]

Is this any good?

select id, date, sum(amount), chequeid, max(transid)
from tblCheck
group by id, date, chequeid

 

[Jhankins]

No that still returns the 4 rows

 

[r937]

select id
     , convert(char(10),date,3) as thedate
     , sum(amount)
     , chequeid
     , max(transid)
  from tblCheck
group 
    by id
     , convert(char(10),date,3)
     , chequeid

rudy

http://r937.com/

SQL Consulting

 

[Jhankins]

Thanks for that.