MySQL GROUP BY返回一行

Question

I need to get total no of unique rows on daily ip bases, Repeating ip on another day shall be counted for row.

I also followed these link, link, approach's but didn't worked

I am doing this way

Database

|    ip      |  date    |
| 1698170033 | 19032016 |
| 1698170034 | 19032016 |
| 1698170033 | 19032016 |
| 1698170033 | 20032016 |
| 1698170034 | 20032016 |
| 1698170035 | 20032016 |
| 1698170036 | 20032016 |
| 1698170033 | 20032016 |

MySQl

SELECT 
`date`, `ip`
FROM `stats`.`stats`    
GROUP BY `date`

This gives result as

| 1698170033 | 19032016 |
| 1698170033 | 20032016 |

Expected result

| 1698170033 | 19032016 |
| 1698170033 | 20032016 |
| 1698170034 | 20032016 |
| 1698170035 | 20032016 |
| 1698170036 | 20032016 |

Please suggest any possible way to do this.

Thanks

Answer 1

You need to GROUP BY ip field too:

SELECT `date`, `ip`
FROM `stats`.`stats`    
GROUP BY `date`, `ip`

This will give you a distinct list of all the date, ip pairs of your table.