如何编写“订购依据"；在“在何处"之前的条款条款 [英] How to write "Order By" clause before "Where" clause

问题描述

我想在WHERE条件之前写一个ORDER BY子句，因为我需要将结果截断为10个，但是我需要首先按字母顺序对其进行排序.

I want to write an ORDER BY clause before my WHERE condition because I need to truncate my results to just 10, but I need to sort them in alphabetical order first.

我知道您不能将ORDER BY放在WHERE之前，怎么办?

I know that you can't put ORDER BY before WHERE so how can I do it?

我需要执行以下操作:

SELECT *
FROM myTable
ORDER BY TOP10
WHERE ROWNUM <=10

推荐答案

您可以为此使用内联视图

You can use an inline view for this

SELECT * 
FROM (
 SELECT *
 FROM myTable
 ORDER BY TOP10) T
WHERE ROWNUM <=10

这篇关于如何编写“订购依据"；在“在何处"之前的条款条款的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！