I am going to share how to count more than one row in SQL. Suppose You have list of user details and you want count more then one row. In bellow example you can use sql query to get data.
Example
| id | name | Date |
|---|---|---|
| 1 | umesh | 2016-11-01 |
| 2 | dinesh | 2016-11-01 |
| 3 | umesh | 2016-11-01 |
| 4 | rajesh | 2016-11-01 |
| 5 | rajesh | 2016-11-01 |
What I want:
| name | Date | count_name |
|---|---|---|
| rajesh | 2016-11-01 | 2 |
| umesh | 2016-11-01 | 2 |
SELECT `name`,`date`, COUNT(`name`) AS `count_name` FROM test1 GROUP BY `name` HAVING ( COUNT(`name`) > 1 )