SQL子查询min()不工作

Question

如何获得无法工作的Select语句(Oracle11g)？

作品：

SELECT * FROM (Select statement that returns 4 rows) where Column1= 1

不管用：

SELECT * FROM (Select statement that returns 4 rows) where Column1= MIN(Column1) 

这里不允许Error=群函数

不管用：

SELECT * FROM (Select statement that returns 4 rows) where Column1= MIN(Column1) 
Group by (names of columns in select statement)

相同的群函数错误

Answer 1

SELECT * FROM (由Column1 ASC返回4行顺序的Select语句)，其中rownum <= 1

Answer 2

在Server或Oracle中，尝试使用窗口函数：

select s.*
from (select s.*, min(column1) over () as mincolumn1
      from  (Select statement that returns 4 rows
            ) s
     ) s
where Column1 = minColumn1;