兩種方法,壹種是查詢重復的數據,只查詢重復記錄,不管其余信息,如ID什麽的:
select?uid,?time?from?ztest?GROUP?BY?uid,?time?having?count(*)>1;查出結果是
uid time
1 1
還有壹種是查詢妳指定信息,可以查詢出ID信息:
select?distinct?a.id,?a.uid,?a.time?from?ztest?a?join?ztest?b?on?a.id?!=?b.id?where?a.uid?=?b.uid?and?a.time?=?b.time;查詢結果是:
id uid time
1 ? 1 ? 1
3 ? 1 ? 1