transfield Posted April 8, 2008 Share Posted April 8, 2008 Hello. I need to know how to write a query. The scenario is below. I've got 2 columns in a Mysql database. The names of the columns are Approved_Year & State. The sample with some records are below:- Approved_Year | State 2006 | Perlis 2006 | Johor 2007 | Kedah 2008 | Perlis 2008 | Perlis 2008 | Kedah I want to count how many records appear for Perlis on a yearly basis. The answer should looks like this:- Year 2006 - 1 records Year 2007 - 0 records Year 2008 - 2 records I know how to connect to the Mysql database & I know how to display the records so we can skip these steps. I just need to know how to write the query. Thanks for your help. Link to comment https://forums.phpfreaks.com/topic/100138-counting-records-query-help/ Share on other sites More sharing options...
fenway Posted April 8, 2008 Share Posted April 8, 2008 select approved_year, count(*) from <your-table-name> where state = 'perlis' group by state order by approved_year Link to comment https://forums.phpfreaks.com/topic/100138-counting-records-query-help/#findComment-512026 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.