Posted by Spook on 03/14/07 03:04

I have a SQL table with the following fields:

accounts, orderid's and datetime



Account OrderID Datetime
1 1 2007-03-01 09:30
1 2 2007-03-01 09:35
10 3 2007-03-01 10:30
2 4 2007-03-01 11:30
10 5 2007-03-01 12:30


Using Query Analyzer, I'd like to run a query where the results are a count
of orderId's by account on any given day like what I have below:



Account Orders Date
1 2 2007-03-01
2 1 2007-03-01
10 2 2007-03-01


Eventually getting it to this output:

Date TotalOrder
2007-03-01 5

Thanks for the help!

• Next in forum: Re: Identity reused problem
• Prev in forum: Re: CREATE VIEW - script to automate column names?
• Thread view: SQL Query help

[Reply to this message]