sql语句问题 求解

[w521111]

表 tab
字段：id，name，num

要求：查出表tab中数据，按num倒序排列，当name重复时只显示num最大的一条

[AcHerat]

select *
from tbt
where not exists (select 1 from tb where name = t.name and num < t.num)
order by num desc

[xuam]

select id，name，max(num) from tab order by num desc

[AcHerat]

select *
from tb t
where not exists (select 1 from tb where name = t.name and num < t.num)
order by num desc

[打一壶酱油]

select *
from tb t
where not exists (select 1 from tb where id = t.id and num < t.num)
order by num desc

[快溜]

 select * from tab a where not exists(select 1 from tab num>a.num and name=a.name)
order by num desc

[w521111]

select * from tab a where not exists(select 1 from tab b where name=a.name and num>a.num) order by num desc

2楼的自己试试看
3、4楼的应该是num>a.num，不存在比a中num更大的
5楼的括号中少了个where

[AcHerat]

[Quote=引用 6 楼 w521111 的回复:]
select * from tab a where not exists(select 1 from tab b where name=a.name and num>a.num) order by num desc

2楼的自己试试看
3、4楼的应该是num>a.num，不存在比a中num更大的
5楼的括号中少了个where
[/Quote]

被你发现了。

[w521111]

[Quote=引用 7 楼 acherat 的回复:]

被你发现了。……
[/Quote]

那个SQL Code框是怎么用的？没找到按钮啊