箱式电阻炉加热元件:Select min(id) as id,bid from zhan group by bid
来源:百度文库 编辑:杭州交通信息网 时间:2024/05/08 16:47:53
Select min(id) as id,bid from zhan group by bid
这样正确不重复BID,我要在增加一个字段,如何加?
Select min(id) as id,bid,cid 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
在查询语句中出现聚合函数的话其他没有被聚合的字段必须分组
Select min(id) as id,bid from zhan group by bid
select distinct id ,num=sum(cast((num) as int) from sy order by id desc
select * from table1 where id in (select id from table2),
select @id=id from [dbo].[table1] where id > -1 order by id ASC
select * from buy where id= 261
stb="select top 1 id FROM our order by id "
sql="select * from exam_subject where id="& cint(id(j))是什么意思?
sql="select * from main where id="&id 这句啥意思
sql="select * from main where id="&id 这句啥意思
sql="select * from spzs where id="+cstr(id)+" order by id desc" 意思