sql - 想要获取所有最小值，包括重复值

Question

''' select min(ps_supplycost) as "cheapest" from partsupp where ps_partkey = 3753; '''

标签： sqloracle

Answer 1

从 Oracle 12 开始，您可以使用：

SELECT ps_supplycost AS cheapest
FROM   partsupp
WHERE  ps_partkey = 3753
ORDER BY ps_supplycost ASC
FETCH FIRST ROW WITH TIES;