Solved

Record count by day / date

Posted on 2011-02-14
4
312 Views
Last Modified: 2012-06-27
Hi All,

What would be the sql for a record count by date for this table?

select txn_id, labelid, value, months, date, proc_dd, proc_mm,proc_yyyy from history

Thanks
0
Comment
Question by:lp84
4 Comments
 
LVL 8

Expert Comment

by:kingjely
ID: 34893686
select count(txn_id) as count, txn_id, labelid, value, months, date, proc_dd, proc_mm,proc_yyyy from history
group by day(date)

Something like the above

0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 34893725
like this probably

if you want more we need the data types of the columns and some sample
data would also be nice....


select proc_yyyy,proc_mm,proc_dd,count(*) as records
from history
group by proc_yyyy,proc_mm,proc_dd
order by 1 desc,2 desc,3 desc

Open in new window

0
 

Author Comment

by:lp84
ID: 34893742
they are all text and value is numeric and date is date
0
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 500 total points
ID: 34893897
select date, count(*) as recordcount  from history
group by date
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
export sql results to csv 6 35
SQL Querying data from 3 tables, all with 1 common column 4 34
SQL Error - Query 6 24
Can > be used for a Text field 6 39
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question