sql如何实现这样的效果?请指点

[tanyuqiong]

MenuID OperationID MenuDesc MenuHref
A000601 1 AAA
A000601 3 AAA
A000601 4 AAA
B000701 2 BBB
B000701 3 BBB
C000301 2 CCC
D000402 3 DDD

要求:如MenuID相同的则取其OperationID最大的记录

[99831323]

select * from tablename a
where not exists (
select 1 from tablename
where MenuID=a.MenuID and OperationID>a.OperationID
)

[HelloWorld_001]

select a.* from table a,(
select MenuID,max(OperationID) as OperationID from table
group by MenuID ) b
where a.MenuID=b.MenuID and a.OperationID=b.OperationID

[99831323]

or:
select * from tablename a
where OperationID=(
select top 1 OperationID from tablename
where MenuID=a.MenuID
order by OperationID desc
)

[jyxhz]

select a.* from 表 a,(select MenuID,mo=max(OperationID) from 表 group by MenuID) b where a.MenuID=b.MenuID and a.OperationID=b.mo

[shuai45]

select * from 表 as T
where MenuID =(select min(MenuID) from 表 where MenuID=T.MenuID)

[谢良]

select * from 表 as T
where MenuID =(select max(MenuID) from 表 where MenuID=T.MenuID)

[tanyuqiong]

我已解决...谢谢了