firemail

标题: 查询多字段相同的数据 [打印本页]

作者: java 时间: 2018-7-31 19:46
标题: 查询多字段相同的数据
select user_id,calendar_id,owner_id,count(*) c from user_calendar uc where uc.status = 0 GROUP BY user_id,calendar_id,owner_id HAVING c > 1;

欢迎光临 firemail (http://firemail.wang:8088/)