需要在求最小时间后使用嵌套语句。 如emp表中数据如下: 先要查出hiredate中最小的,然后并获取其他字段的数据,可用如下语句: select * from emp where hiredate in (select min(hiredate) from emp);查询结果:
实现例句如下: SELECT a.* FROM table1 a WHERE NOT EXISTS (SELECT 1 FROM table1 b WHERE b.id>a.id) 或者 SELECT * FROM table1 WHERE id IN (SELECT Max(id) FROM table1) 又或者 SELECT * FROM table1 WHERE id=(SELECT Max(id) FROM table1)
对这类没悬赏又长的题不太喜欢回答,不过为了采纳率,还是告诉你办法吧。 把你写的东西看成是一个table,再连接要获取字段的对应table就可以了,是不 是很简单? select * from ( select tablea.车牌, tablea.数值, tablea.序号, min(tablea.数值-t...
SELECT * FROM A WHERE C4 IN (SELECT MIN(C4)KEEP(DENSE_RANK LAST ORDER BY C1) FROM A GROUP BY AGG,ITEM)
select max(case when d.cnt = d.max_cnt then d.crown else null end) as max_crown,d.max_cnt, max(case when d.cnt = d.min_cnt then d.crown else null end) as min_crown, d.min_cnt from ( select s.crown, s.cnt, max(s.cnt) over () as ...
可以, select max(cola),min(cola) from tab
每行的每个字段都去算大小.在来比较大小.. 就把行换成列...在去比较
使用least求最小数,例如会返回1 select least(4,1,33,6) from dual;
select * from 表 where rownum
select A.某个字段 as 某个字段最大值, B.某个字段 as 某个字段最小值 from (select 某个字段, rownum from 表 where rownum