mssql 查询时，有相同记录，我以最大id为准，怎么写？

[yangyaodell]

比如

id name pass
1 admin erere
2 admin fdsfd
3 admin 4e3f
4 admin 43f34
5 admin 3c3c3
6 admin 3df3cd
7 admin 3d2d3


在查询操作的时候，我要以 最大的id的数据为准，也就是 id=7 的这行数据，sql 语句怎么写？

[winner2050]

也不用那么麻烦.

select top 1 * from T where Name='admin' order by ID Desc

[Dogfish]

[Quote=引用 2 楼 luxu001207 的回复:]
SQL code
--如果要查所有列，试试这条语句
select * from mytable where id in(select max(id) from mytable group by [name])
[/Quote]
2楼正确

[zzxap]

select * from mytable where id in(select max(id) from mytable group by [name])

[贝利网络]

select top 1 * from T where Name='admin' order by ID Desc

[Atai-Lu]

select max(id),[name] from mytable group by [name]

[Atai-Lu]

--如果要查所有列，试试这条语句
select * from mytable where id in(select max(id) from mytable group by [name])

[lbcleo]

select * from mytable where id in(select max(id) from mytable group by [name])