C#数据库重新排序

问题描述

看看我是否有这样的数据库

See if I have a database like this

Table Headers    Category  City  Serial_no

Table Content    Dealer    Agra     1
                 Dealer    Agra     2
                 Dealer    Chennai  3

现在，当我添加另一条记录Dealer Agra 3时，表内容应更改为

Now when I add another record Dealer Agra 3, then the table content should change to

Dealer    Agra     1
Dealer    Agra     2
Dealer    Agra     3
Dealer    Chennai  3

应在不使用自动ID的情况下实现

请帮助我.

This should be achieved without using auto id

Please help me.

推荐答案

SELECT Category, City, ROW_NUMBER() OVER(ORDER BY City)
FROM YourTable
ORDER BY City

这篇关于C#数据库重新排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！