Phil Chapman
asked on
Grouping Records By Year Query
The query below gives me the total accounts with the same submission date. But I need the total accounts with the same year only.
What needs to be changed in the query?
SubmissionDate is a DateTime datatype
SELECT count(account)as NumOfAccounts,SubmissionDa te
FROM Accounts
Group By SubmissionDate HAVING count(account)> 0
What needs to be changed in the query?
SubmissionDate is a DateTime datatype
SELECT count(account)as NumOfAccounts,SubmissionDa
FROM Accounts
Group By SubmissionDate HAVING count(account)> 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks