摘要: table sturcture {taskRecordId,taskDate,userId,teamId,taskId,unit,nots}delete duplicate taskDate,UserId,teamId and taskId.the sql isdelete from TaskRecordselect * from TaskRecordwhere taskRecordId in (select MIN(taskRecordId) from TaskRecord t join(select COUNT(*) d,taskDate,userId,teamId from TaskR. 阅读全文
posted @ 2011-09-07 14:06 cwe 阅读(789) 评论(0) 推荐(0)