重新编号一组行
- 作者: 晴晴11543527
- 来源: 51数据库
- 2023-02-07
问题描述
我有一个包含数据的表格,如下所示:
I have a table with data which looks something like the following:
# the columns # url title group id_within_group http://www.google.com google search engine 1 http://www.51sjk.com/Upload/Articles/1/0/342/342613_20230207091027468.com yahoo search engine 2 http://www.51sjk.com/Upload/Articles/1/0/342/342613_20230207091030704.com bing search engine 3 http://www.facebook.com facebook social media 1 http://www.twitter.com twitter social media 2
如果我这样做
select * from table1 where group = "search engine"
我会得到
http://www.google.com google search engine 1 http://www.51sjk.com/Upload/Articles/1/0/342/342613_20230207091027468.com yahoo search engine 2 http://www.51sjk.com/Upload/Articles/1/0/342/342613_20230207091030704.com bing search engine 3
我希望能够删除这些行中的任何一行,但以某种方式让它重新编号 id_within_group.
I would like to be able to delete any of these rows, but somehow get it to renumber the id_within_group.
所以,如果我从上面的 3 个中删除第二个,它应该自动重新编号然后留给我
SO if I delete the second one from the 3 above, it should automatically renumber then leaving me with
http://www.google.com google search engine 1 http://www.51sjk.com/Upload/Articles/1/0/342/342613_20230207091030704.com bing search engine 2
这可能吗?
推荐答案
如果您只需要显示连续整数,我的建议是在 SELECT 中执行此操作.
My suggestion would be to do this in the SELECT if you just need to display a sequential integer.
SELECT url , title , [group] , id_within_group , ROW_NUMBER() over (partition BY [group] ORDER BY id_within_group) AS sequential_index FROM YourTable
推荐阅读
热点文章
检查拆分键盘
0
带有“上一个"的工具栏和“下一个"用于键盘输入AccessoryView
0
Activity 启动时显示软键盘
0
UIWebView 键盘 - 摆脱“上一个/下一个/完成"酒吧
0
在 iOS7 中边缘滑动时,使键盘与 UIView 同步动画
0
我的 iOS 应用程序中的键盘在 iPhone 6 上太高了.如何在 XCode 中调整键盘的分辨率?
0
android:inputType="textEmailAddress";- '@' 键和 '.com' 键?
0
禁用 iPhone 中键盘的方向
0
Android 2.3 模拟器上的印地语键盘问题
0
keyDown 没有被调用
0