表 table1 的数据
ID Value1 Value2
1 A abc
2 A cda
3 B grdc
4 B ytrcv
5 B mkgdf
6 C gfrf
7 C gre
8 D zide
9 E grsj
10 E ucvidf如何用sql语句组织查询 显示成下面内容 ID Value1 Value2
1 A abc
3 B grdc
6 C gfrf
8 D zide
9 E grsj
2 A cda
4 B ytrcv
7 C gre
10 E ucvidf
5 B mkgdf根据 Value1 列的数据进行交叉循环排序
ID Value1 Value2
1 A abc
2 A cda
3 B grdc
4 B ytrcv
5 B mkgdf
6 C gfrf
7 C gre
8 D zide
9 E grsj
10 E ucvidf如何用sql语句组织查询 显示成下面内容 ID Value1 Value2
1 A abc
3 B grdc
6 C gfrf
8 D zide
9 E grsj
2 A cda
4 B ytrcv
7 C gre
10 E ucvidf
5 B mkgdf根据 Value1 列的数据进行交叉循环排序
from tb
order by rid,value1
select *
from tb
order by row_number() over (partition by value1 order by id),value1