将数据怎么随机分组。

很臭很烂很彪 2006-07-04 09:28:00
111,"06000091"
111,"106000888"
111,"06001738"
111,"06002768"
111,"06003663"
111,"06042055"
111,"06043508"
111,"06043515"
111,"06043518"
111,"06043519"
111,"106000888"
111,"06001738"
111,"06002768"
111,"06003663"
111,"06042055"
111,"06043508"
111,"06043515"
111,"06043518"
111,"06043519"
111,"06043522"
111,"06043523"
111,"06043525"
111,"06043529"
111,"406043533"
111,"06043535"
111,"06043538"
111,"06043551"
111,"06043552"
111,"06043556"
111,"06043557"
111,"06043561"
111,"06043562
111,"06043522"
111,"06043523"
111,"06043525"
111,"06043529"
111,"406043533"
111,"06043535"
111,"06043538"
111,"06043551"
111,"06043552"
111,"06043556"
111,"06043557"
111,"06043561"
111,"06043562

SQL数据库里有一个表, 表里有两个字段,我想怎么将数据3行为一组进行分组,然后将第一个字段的值111,分成如下的格式。

7,"06043519"
7,"106000888"
7,"06001738"
8,"06002768"
8,"06003663"
8,"06042055"
9,"06043508"
9,"06043515"
9,"06043518"
10,"06043519"
10,"06043522"
10,"06043523"
11,"06043525"
11,"06043529"
11,"406043533"
12,"06043535"
12,"06043538"
12,"06043551"
13,"06043552"
13,"06043556"
13,"06043557"
14,"06043561"
15,"06043562
10,"06043522"
10,"06043523"
11,"06043525"
11,"06043529"
11,"406043533"
12,"06043535"
12,"06043538"
12,"06043551"
13,"06043552"
13,"06043556"
13,"06043557"
14,"06043561"
15,"06043562"
...全文
355 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
洛卓思学 2006-07-06
  • 打赏
  • 举报
回复
还是用程序实现吧。

2,598

社区成员

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧