SQL3 之常用查询 LIKE ORDER BY 选取关键字、排序

1. LIKE

取特定的合约。eg：股指期货

((contract LIKE 'IC_%_%1%_%' ) OR (contract LIKE 'IC_%_%0%_%'))

2. ORDER BY

ORDER BY 语句用于根据指定的列对结果集进行排序。

ORDER BY 语句默认按照升序对记录进行排序。

如果您希望按照降序对记录进行排序，可以使用 DESC 关键字

SELECT Company, OrderNumber FROM Orders ORDER BY Company

SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC

SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC