t1.name,
row_number() over(PARTITION BY t1.id order by t1.name) rowss1,--第一条
row_number() over(PARTITION BY t1.id order by t1.name desc) rowss2--倒数第一条
from
t_test t1
where
t1.pid=
'
0
'
where
rowss1=
'
1
'
or rowss2=
'
1
'
) GROUP BY id
不分组的话去掉
PARTITION BY t1.id
