Question

sql根据某一个字段重复只取第一条数据

Answer 1

代码如下：

select * from tbl_DPImg where ID in (select min(ID) from tbl_DPImg group by DPID)

处理后结果为:

查找表中多余的重复记录，重复记录是根据单个字段（teamId）来判断

select * from team where teamId in (select teamId from team group by teamId having count(teamId) > 1) 

删除表中多余的重复记录，重复记录是根据单个字段（teamId）来判断，只留有rowid最小的记录 

delete from team where

teamName in(select teamName from team group by teamName having count(teamName) > 1) 

and teamId not in (select min(teamId) from team group by teamName having count(teamName)>1)

扩展资料

数据记录筛选：

sql="select * from 数据表 where字段名=字段值 order by字段名[desc]"（按某个字段值降序排列。默认升序ASC）

sql="select * from 数据表 where字段名like '%字段值%' order by 字段名 [desc]"

sql="select top 10 * from 数据表 where字段名=字段值 order by 字段名 [desc]"

sql="select top 10 * from 数据表 order by 字段名 [desc]"

sql="select * from 数据表 where字段名in ('值1','值2','值3')"

sql="select * from 数据表 where字段名between 值1 and 值2"

参考资料来源：百度百科：SQL语句大全