跳转到内容
View in the app

A better way to browse. Learn more.
彼岸论坛

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
欢迎抵达彼岸 彼岸花开 此处谁在 -彼岸论坛

[数据库] 如何对 SQLite 数据库中的表进行分组之后的结果再进行分组？

发表于

在 SQLIte 数据库中有一张表，表中的内容如下所示：

group1 index
1 1
1 1
1 2
1 2
1 4
1 4
2 1
2 1
2 3
2 3
2 4
2 4

现在希望能够以group进行分组，并在该组内以每两行数据为一组进行升序编号，编号的结果如下所示：

group index
1 1
1 1
1 2
1 2
1 3
1 3
2 1
2 1
2 2
2 2
2 3
2 3

请问能使用 SQL 语句实现吗？如果能的话，麻烦大佬指点一二。非常感谢🙏🙏

Featured Replies

No posts to show

创建帐户或登录来提出意见

https://www.cnbian.com/topic/8082/
前往主题列表

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.