mysql - 每天的独特值(value)

Question

我正在寻找如何每天拥有独特的值(value)，这里是一个例子:

CREATE TABLE IF NOT EXISTS calls (
  id int(11) default NULL,
  calldate datetime default NULL,
  dst varchar(80) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO calls (id, calldate, dst) VALUES
(1, '2014-05-03 20:45:43', '22561037352'),
(2, '2014-05-04 20:07:49', '22561037352'),
(3, '2014-05-04 13:16:14', '22561037352'),
(4, '2014-05-04 20:08:58', '22560991034'),
(5, '2014-05-04 16:06:02', '22560991034'),
(6, '2014-05-04 20:22:19', '22560842218');

sqlfiddle: Copy and paste to test

我们每天有两个号码来两次 22561037352 和 22560991034，我想每天显示唯一的号码。

Answer 1

http://sqlfiddle.com/#!9/84076/11

SELECT DISTINCT DATE_FORMAT (calldate,'%Y-%m-%d') calldate, dst
FROM calls