|
View previous topic :: View next topic
|
| Author |
Message |
cheetz007
New User
Joined: 10 Aug 2006
Posts: 23
|
|
|
|
Hi,
I have a table with rows that have a transaction date. I want to list the number of rows and the transaction date for each transaction date, so my output would look something like:
| Code: |
Trans Date Number of rows with that date
01/08/2006 45
02/08/2006 23
03/08/2006 101
etc
|
.
I want to do this using SPUFI, therefore I was thinking that COUNT should be able to do this, but I'm not too sure how I would go about it - I think maybe I will need to use group by and having, maybe?
Any ideas?
|
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Select count(*), trans_date
from table
Group by trans_date |
|
| Back to top |
|
|
cheetz007
New User
Joined: 10 Aug 2006
Posts: 23
|
|
|
|
Oh dear, that's embarrasingly simple!
Thanks, it works a treat. |
|
| Back to top |
|
|
|
|
