简单的写一篇.关于取重复的数据.
摘要:
表中有1,2,3,4,4,4,5,5,6等值,我要把3个4和2个5提取出来(共是5条记录)id tid1 12 23 34 45 46 47 58 59 6select * from table1 where tid in (SELECT tid FROM table1 group BY tid having count(id)>1)以前我还一致以为要分两条SQL去写,今天G了篇文章才发现h... 阅读全文
posted @ 2005-10-18 17:40 Blackie 阅读(637) 评论(0) 推荐(0) 编辑