Reputation: 164
How to count the items which have same value using SQL?
These are my data:
equipment re_date remark
AHU# 1 2/1/2014 bag filter dirty
AHU# 1 2/3/2014 bag filter dirty
AHU# 1 2/4/2014 bag filter dirty
AHU# 1 2/5/2014 bag filter dirty
AHU# 1 2/8/2014 bag filter dirty
AHU# 1 2/10/2014 bag filter dirty
AHU# 1 2/11/2014 bag filter dirty
AHU# 1 2/12/2014 bag filter dirty
AHU# 1 2/13/2014 bag filter dirty
AHU# 1 2/15/2014 bag filter dirty
AHU# 1 2/18/2014 bag filter dirty
AHU# 1 2/19/2014 bag filter dirty
AHU# 1 2/20/2014 bag filter dirty
AHU# 1 2/23/2014 bag filter dirty
AHU# 14 2/1/2014 unit off
AHU# 14 2/3/2014 unit off
AHU# 14 2/4/2014 unit off
AHU# 14 2/5/2014 unit off
AHU# 14 2/6/2014 unit off
AHU# 14 2/8/2014 unit off
AHU# 14 2/10/2014 return fan off
AHU# 14 2/11/2014 unit off
AHU# 14 2/12/2014 unit off
AHU# 14 2/13/2014 unit off
AHU# 14 2/15/2014 unit off
AHU# 14 2/18/2014 unit off
AHU# 14 2/19/2014 unit off
AHU# 14 2/20/2014 unit off
AHU# 14 2/23/2014 unit off
AHU# 14 2/26/2014 unit off
AHU# 17 2/3/2014 bag filter dirty
AHU# 17 2/5/2014 bag filter dirty
AHU# 17 2/8/2014 bag filter dirty
AHU# 17 2/10/2014 bag filter dirty
AHU# 17 2/11/2014 bag filter dirty
AHU# 17 2/12/2014 bag filter dirty
AHU# 17 2/13/2014 bag filter dirty
AHU# 17 2/15/2014 bag filter dirty
can you help me please to get the count of items have same value in first column.
Upvotes: 0
Views: 56
Answers (1)
Related Questions
- SQL query count rows with the same entry
- How do you count the number of rows in a table that have the same value in value in a column?
- Count amount of same value
- Count how many rows with the same value
- Count how many rows have the same value in msql database
- How to count rows in database with the same value?
- Mysql count number of rows which have same value
- How to count rows that have the same values in two columns (SQL)?
- SQL Count: How to get a count on identical values in a table
- count of same item to calculate count