找出重复值的SQL语句
摘要:
如:venderno 有重复的列表,这里只指定了一天.语句如下 select venderno from po where pdate='2003-9-3' group by venderno having count(*) >=2进一步应用SELECT vno,shortname FROM vendor WHERE vno in(select venderno from po where pda... 阅读全文
posted @ 2006-06-16 16:23 人淡如菊 阅读(747) 评论(0) 推荐(0) 编辑