一起来看流星雨端木磊:Select min(id) as id,bid from zhan group by bid

来源:百度文库 编辑:中科新闻网 时间:2024/05/17 14:06:47
Select min(id) as id,bid from zhan group by bid
这样正确不重复BID,我要在增加一个字段,如何加?
Select min(id) as id,bid,cid from zhan group by bid
这样不对

Select min(id) as id,bid,cid from zhan group by bid, cid
在查询语句中出现聚合函数的话其他没有被聚合的字段必须分组