'Select Values based on Distinct Dates

I am puzzled for a while now. I have a table with phone numbers and dates(Timestamp). If a number exists more than once for a particular date, the number should be returned only once.

           Date               Number
     2013-05-14 15:39:19     1234567890
     2013-05-14 15:39:19     1234567890
     2013-05-14 15:39:19     9876543210
     2013-05-14 15:39:20     1234567890

Output:

           Date               Number
    2013-05-14 15:39:19     1234567890
    2013-05-14 15:39:19     9876543210
    2013-05-14 15:39:20     1234567890

I know this doesn't serve my need but i tried select * from table name group by Date and didn't get the desired result as expected. How should I go about?

mysql


Solution 1:[1]

 select * from table name group by Date,Number

Sql Fiddle Demo

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions