关于Group By 问题

Question

这个是我数据库表的结构及数据

我需要读出id_huiyuan=340982,的数据，如果有重复，则只显示一条。

这个是我目前的SQL，这样的写法，是只能读出“货物2”，“货物3”，货物1没有读出来

```sql
  sql="select * from sell where ID In (Select Max(ID) from sell Group By huohao) and id_huiyuan=340982  order by id desc"

```

Answer 1

子查询里面的问题

 

select * from sell where ID In (Select Max(ID) from sell where
id_huiyuan=340982  Group By huohao) and id_huiyuan=340982  order by id desc