问个SQL语句 Table1ID KeHuID1 50 2 60 3 50 4 50 5 60 6 70 想得到唯一的KeHuID,而且该条记录中ID最大 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from table1 t where not exists(select 1 from table1 where KeHuID=t.KeHuID and id>t.id) SELECT *FROM tb AS aWHERE ID=( SELECT MAX(ID) FROM tb WHERE KeHuID=a.KeHuID ); Select max(ID),KeHuIDfrom Table1 group by KeHuID Table1 ID KeHuID -select max(id) as id ,kehuidfrom table1group by kehuid ID KeHuID select * from Table1 tt where not exists (select * from Table1 where KeHuID =tt.KeHuID and ID<tt.ID) 应该是这个意思吧,上面的大家都把题意理解错误select top 1 KeHuID,ID from Table1 order by ID desc 求教个sql的写法 求一sql语句 大家帮忙看看这种字符串怎么处理 重复记录 ; distinct ;Text类型 的问题 来个高手帮我解决一下这问题 sql 分页取每页最后一条 存储过程中某个参数中包含 单引号 怎么解决 ??? 这个怎么做? 这个两层递归的语句该怎么写? 请教关于锁的问题? sql数据库中,可以使用汉字作为字段吗??? sql查询不为真的数据 连接数据库时报错
FROM tb AS a
WHERE ID=(
SELECT MAX(ID)
FROM tb
WHERE KeHuID=a.KeHuID
);
from Table1
group by KeHuID
ID KeHuID -select max(id) as id ,kehuid
from table1
group by kehuid
select * from Table1 tt where not exists (select * from Table1 where KeHuID =tt.KeHuID and ID<tt.ID)
from Table1
order by ID desc