Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Reply
query with agrregate function
Sasi Reddy
10 years ago
839
Reply
The table structure like this
Cr_By Date
1 2014-09-09 04:40:57.463
1 2014-09-09 04:55:10.700
sSql = " SELECT *FROM WF_Dailyreport WHERE DATEPART(yyyy, WF_CrOn) = " & year & " AND DATEPART(mm, WF_CrOn) = " & month & " AND WF_CrBy=" & crby & ""
If i select the user and month and year for above query i am getting both rows
but i need count as 1
how to get that count?..
please tell me..
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Urgent:Reply for the output in the form of SQL Script?
Merge Replication with Web Synchronization