SQL ORDER BY多列
SQL对多个列进行排序
让我们以包含许多列的customer表为例,以下SQL语句从“ counter”和“ Customer-Name”列存储的名为“ customer”的表中选择所有客户:
SELECT * FROM customers ORDER BY country, Customer-Name;
上一篇: SQL ORDER BY LIMIT
下一篇: SQL插入
让我们以包含许多列的customer表为例,以下SQL语句从“ counter”和“ Customer-Name”列存储的名为“ customer”的表中选择所有客户:
SELECT * FROM customers ORDER BY country, Customer-Name;
总计 0 评论