mysql - 按对对记录进行分组 SQL 查询

Question

我有这样的表格，它应该描述室友的一对。

    name| surname | city      | distance|sex | roomate
    -----------------------------------------------------
    Mike|  Tyson  | London    | 599     | M  | Oliver Red
    -----------------------------------------------------       
    Ron | Simpson | Newcastle | 4       | M  | John Godson
    -----------------------------------------------------
    Tim | Black   | Dover     | 311     | M  | 
    -----------------------------------------------------
    John| Godson  | Calais    | 111     | M  | Ron Simpson
    -----------------------------------------------------
    Oliver| Red   | Dover     | 99      | M  | Mike Tyson

是否可以像上面那样对和距离列进行排序？如果没有，是否可以像对一样对数据进行排序？更重要的是;)

    name  | surname |   city    | distance|sex | roomate
    -----------------------------------------------------
    Mike  |  Tyson  | London    | 599     | M  | Oliver Red
    -----------------------------------------------------
    Oliver| Red     | Dover     | 99      | M  | Mike Tyson
    -----------------------------------------------------
    John  | Godson  | Calais    | 111     | M  | Ron Simpson
    -----------------------------------------------------
    Ron   | Simpson | Newcastle | 4       | M  | John Godson
    -----------------------------------------------------
    Tim   | Black   | Dover     | 311     | M  | 
    -----------------------------------------------------

Answer 1

是的。您可以按列名称对结果进行排序。 (例如距离、室友)。

SELECT * FROM table ORDER BY distance, roommate;