Question

asp 数据库问题

我想用group by把所有类型相同的组成一组,可是用 select * form pho group by cate不能用,不知道有什么方法可以实现我的想法,谢谢各位了!

Answer 1

select * from pho where cate in (select distinct(cate) from pho group by cate)

其实用
select * from pho order by cate 即可

如果要制定类型 就要where cate=''

Answer 2

select cate form pho group by cate
因为你查询的列,必须包含在group by 里面,或者进行聚合查询,如count,sum,avg等等.把你要分组的列,放在group by 里面之后,就可以了

Answer 3

select * form pho where group by cate

Answer 4

不错。。。