sql语句

SELECT channel_uid,channel,sid,MIN(DATE) AS DATE FROM xxxx GROUP BY channel_uid,channel,sid HAVING DATE='2018-06-13';

　　

SELECT p.channel_uid,p.channel,DATE_FORMAT(a.register_time,'%Y-%m-%d') AS reg_date,DATE,(TO_DAYS(DATE)-TO_DAYS(DATE_FORMAT(a.register_time,'%Y-%m-%d'))) AS daynum ,p.money FROM payment p,accounts a  WHERE p.date='2018-08-23' AND p.channel_uid=a.channel_account_id AND p.channel=a.channel_id HAVING daynum IN('0','7','30','90','180');