问在相同的查询中显示前5销售额和最低5销售

EN

SQL>DESC tbl_sales
 Name                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SALES                          NUMBER

SQL> SELECT * FROM tbl_sales;

     SALES
----------
     1
     2
     4
     3
     5
     6

6 rows selected.

SQL> WITH t1 AS (
  select sales, row_number() over (order by sales desc) rn
  from tbl_sales 
),
t2 AS (
  select sales,row_number() over (order by sales asc) rn
  from tbl_sales
)
select t1.sales as "Top 5", t2.sales as "Min 5"
from t1 join t2 on t1.rn = t2.rn where  t1.rn<=5; 

     Top 5  Min 5
---------- ----------
     6      1
     5      2
     4      3
     3      4
     2      5

CREATE TABLE sales AS
SELECT s, 
       trunc(random() * 100000 + 1) AS sales_amount, 
       random_string(10) AS vendor, 
       trunc(random() * 100 + 1) AS vendor_rating
FROM generate_series(1, 100) s;

"s";    "sales_amount";          "vendor";       "vendor_rating"
----    ---------------    ---------------       ---------------
  1;             98274;      "ULbPPdUTRR";                   59

(SELECT *, 'Top 10' FROM sales
ORDER BY sales_amount DESC
LIMIT 5)
UNION
(SELECT *, 'Bottom 10' FROM sales
ORDER BY sales_amount ASC
LIMIT 5)
ORDER BY sales_amount DESC;