请教!消除重复纪录的field1 field2name1 factory1 name1 factory2name2 factory3 name2 factory4我要的结果是name1,factory1nane2,factory3就是field2字段只取第一条纪录,谢谢^_^ [解决办法]
select * from tb a where field2=(select min(field2) from tb b where a.dield=b.field)