请教大虾们一个简单的查询问题，望赐教！谢谢...

[czciou]

表:mytable
Myid price
1 8
2 4
2 6
3 3
3 5
3 7
4 10
4 11
4 50
4 90

查询后：
Myid price
1 8
2 6
3 7
4 90

查询语句怎么写啊？先谢谢了~

[albert_sky]

select myId,max(price) from mytable
group by myId
order by myId

[Mark杨]

select Myid,max(price) from mytable group by Myid

[百年树人]

select myid,max(price) as price from tb group by myid

[hao1hao2hao3]

select myid,max(price) from mytable 
group by myid

[Mark杨]

-->测试数据
declare @tb table (Myid int,price int)

insert into @tb
select 1,8 union all
select 2,4 union all
select 2,6 union all
select 3,3 union all
select 3,5 union all
select 3,7 union all
select 4,10 union all
select 4,11 union all
select 4,50 union all
select 4,90

select myid,max(price) from @tb group by myid

--结果
myid                    
----------- ----------- 
1           8
2           6
3           7
4           90

[xmx2009]

[Quote=引用 1 楼 albert_sky 的回复:]
SQL code
select myId,max(price) from mytable
group by myId
order by myId
[/Quote]
UP

[Mark杨]

select myid,price = max(price) from @tb group by myid

[czciou]

太感谢 了~这么快就得到你们的帮助~