不用组函数(Max) ,取得某列最高值的三种解法

select xxx,jine from bpcmain where policycreday = '20220501' into temp tmp1;
select max(jine) from tmp1;
19420.34
常规做法：
select distinct (jine) from tmp1;

解法1：
select first 1 xxx,jine from bpcmain where policycreday = '20220501' order by jine desc;
 10:09:59  [SELECT - 1 row(s), 0.020 secs]  Result set fetched
... 1 statement(s) executed, 1 row(s) affected, exec/fetch time: 0.020/0.003 sec  [1 successful, 0 warnings, 0 errors]

解法2：
select jine from tmp1
where jine not in
(
 select distinct A.jine from tmp1 A, tmp1 B
 where A.jine < B.jine 
)
 10:09:51  [SELECT - 1 row(s), 1.407 secs]  Result set fetched
... 1 statement(s) executed, 1 row(s) affected, exec/fetch time: 1.407/0.003 sec  [1 successful, 0 warnings, 0 errors]

解法3：
select * from tmp1 where jine >= all(select jine from tmp1);
 10:09:43  [SELECT - 1 row(s), 0.013 secs]  Result set fetched
... 1 statement(s) executed, 1 row(s) affected, exec/fetch time: 0.013/0.003 sec  [1 successful, 0 warnings, 0 errors]