如何在语句中添加顺序

Question

有谁知道如何在下面的语句中插入order

SELECT ctr_num,
       scn
FROM   user_convoy
WHERE  ctr_num LIKE '%" + str_convoy + "%'"

Answer 1

我不太确定你的问题，但根据我的理解，应该是：

select ctr_num , scn from user_convoy where ctr_num like '%" + str_convoy + "%'" ORDER BY your_column

Answer 2

在结尾处添加顺序。SELECT语句的一般格式通常是从WHERE ORDER中选择(当然，假设不进行分组)。请注意，它不区分大小写。

select ctr_num , scn from user_convoy where ctr_num like '%' + str_convoy + '%' ORDER BY ctr_num

Answer 3

ORDER关键字用于按一个或多个列对结果集进行排序。

如果您想使用Order，请在下面试一试。

SELECT ctr_num,
       scn
FROM   user_convoy
WHERE  ctr_num LIKE '%' + str_convoy + '%'
ORDER BY
       ctr_num,scn

欲知更多详情：

请参考w3schools实例并深入了解这