好难!求一SQL语句 select max(ID) as ID,Number from mytable group by Number 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select max(id),numberfrom mytalbegroup by number select Number, [ID]=max(ID)from mytablegroup by Number select max(id) as id ,numberfrom mytablegroup by idorder by id desc 如果ID要排序select max(ID) as ID,Number from mytable group by Number order by max(ID) select max(id) id ,number from myTable group by number 也可以:select * from myTable twhere not exists(select 1 from mytable where Number=t.Number and ID>t.ID) select max(ID) as ID,Number from mytable group by Numberorder by id 哈哈。。好多人回答这个问题。我也来一下吧。select max(ID), Number from mytable group by Number order by id 嘿嘿select Number, [ID]=max(ID)from mytablegroup by Number 急!求一sql语句。关于统计 虚拟机中使用数据库SQL2000问题,帮忙,谢谢了。 请问,SQL SERVER 2005新建数据库的时候那个“使用全文索引”的那个复选框为什么为不可选?我要怎么办呢? sqlinsert 软件在何处下载? 想取出满足不同ID的AA列中最大值的各个记录,怎么写 求一条sql语句,部门人数统计问题 求解顺序创建数据库表格的语句 ,高手请进 都怪我表達有誤.icevi快回來吧.(zhuzhichao) ODBC访问SQL Server 7问题求解(囊肿羞涩 只有22分) master..xp_cmdshell运行报错!急在线等待 编码问题 求SQL语句,在线等,谢谢
from mytalbe
group by number
[ID]=max(ID)
from mytable
group by Number
from mytable
group by id
order by id desc
select max(ID) as ID,Number from mytable group by Number order by max(ID)
select * from myTable t
where not exists(select 1 from mytable where Number=t.Number and ID>t.ID)
order by id
好多人回答这个问题。我也来一下吧。
select max(ID), Number from mytable group by Number order by id
select Number,
[ID]=max(ID)
from mytable
group by Number