老子就这么导分之三:按某一字段分组取最大(小)值所在行的数据

[dawugui]

数据如下：
name val memo
a 2 a2(a的第二个值)
a 1 a1--a的第一个值
a 3 a3:a的第三个值
b 1 b1--b的第一个值
b 3 b3:b的第三个值
b 2 b2b2b2b2
b 4 b4b4
b 5 b5b5b5b5b5
*/

按照name分组获取最大(小)值.



欢迎大家随便接分,但不要仅仅回复mark,接分,顶.可以这么回复:

[windfeel2008]

呵呵，看不出大乌龟是个愤青啊

[haosa]

select T.name,T.val,T.memo from (
select A.*,row_number() over(partition by A.name order by A.val desc ) as row from TB as A
) AS T where T.row = 1

[qgfudi]

select name,max(val),min(val) from 表 group by name

[看看山观观海]

select * from tb a
where not exists (select 1 from tb where name=a.name and val>a.val)
----
select * from tb a
where val (select min(val) from tb where name=a.name)


坐等接分啊

[rnifeasy]

坐等~

[tanwenshuo]

select T.name,T.val,T.memo from (
select A.*,row_number() over(partition by A.name order by A.val desc ) as row from TB as A
) AS T where T.row = 1

[冰凝]

那接点

[jshzp]

怎么回事呀？楼下的说说

[Rock_Wu]

我是来接分的

[Rock_Wu]

路过，此分有危险，但是我还是要来

远远的声援

[一片冰心在玉壶]

回帖删除的厉害。。 不知抽什么风了

[mabailin]

都厉害

[王向飞]

丁页
扌妾 分

不 忄董

[王向飞]

select T.name,T.val,T.memo from (
select A.*,row_number() over(partition by A.name order by A.val desc ) as row from TB as A
) AS T where T.row = 1


其实 我只是
丁页
扌妾 分

不 忄董

[渔舟唱晚，]

[Quote=引用 29 楼 wxf163 的回复:]

select T.name,T.val,T.memo from (
select A.*,row_number() over(partition by A.name order by A.val desc ) as row from TB as A
) AS T where T.row = 1


其实 我只是
丁页
扌妾 分

不 忄董
[/Quote]

[Oraclers]

select name,max(val) as MaxValue,min(val) as MinValue
from TB1
group by name

[laowang134]

[Quote=引用 4 楼 josy 的回复:]

[/Quote]
管理员来删！~

[dianyancao]

C4通往哪里？

[999朵玫瑰]

没被和谐啊

[bancxc]

select * from tb a
where not exists (select 1 from tb where name=a.name and val>a.val)
----
select * from tb a
where val (select min(val) from tb where name=a.name)