suchen

Heim  >  Fragen und Antworten  >  Hauptteil

MySQL: Doppelte Zahlen aufsteigend sortieren

<p>我有一个表格，看起来像这样：</p> <table class="s-table"> <thead> <tr> <th>id</th> <th>values</th> </tr> </thead> <tbody> <tr> <td>1</td> <td>1</td> </tr> <tr> <td>2</td> <td>1</td> </tr> <tr> <td>3</td> <td>1</td> </tr> <tr> <td>4</td> <td>2</td> </tr> <tr> <td>5</td> <td>2</td> </tr> <tr> <td>6</td> <td>2</td> </tr> </tbody> </table> <p> <table class="s-table"> <thead> <tr> <th>id</th> <th>values</th> </tr> </thead> <tbody> <tr> <td>1</td> <td>1</td> </tr> <tr> <td>4</td> <td>2</td> </tr> <tr> <td>2</td> <td>1</td> </tr> <tr> <td>5</td> <td>2</td> </tr> <tr> <td>3</td> <td>1</td> </tr> <tr> <td>6</td> <td>2</td> </tr> </tbody> </table> <p>
P粉763748806P粉763748806549 Tage vor559

Antworte allen(1)Ich werde antworten

  • P粉501683874

    P粉5016838742023-07-26 10:47:39

    在ORDER BY子句中使用ROW_NUMBER()窗口函数：

    SELECT *
FROM tablename
ORDER BY ROW_NUMBER() OVER (PARTITION BY `values` ORDER BY id), 
         `values`;

    可以看看这个 demo.

    Antwort
    0
  • StornierenAntwort