默认看到查询条件有3条结果,我想只查询出日期最晚的那一条记录。
-- 默认查询条件select settledate as "日期", syscalculationmny as "金额" from cdmc_interestlist where pk_financepay in (select pk_financepay from cdmc_financepay where vbillno = 'SFLXQD0036_001') order by settledate desc
把查询条件括起来,加个rownum=1
的筛选条件就能筛选出1行数据。
-- 筛选符合条件的第一条select * from (select settledate as "日期", syscalculationmny as "金额" from cdmc_interestlist where pk_financepay in (select pk_financepay from cdmc_financepay where vbillno = 'SFLXQD0036_001') order by settledate desc ) where rownum=1
两条数据的话要用小于号,等于号我试过了,查询出的结果为空。
喜欢的点个赞❤吧!
Oracle 数据库 - sql语句筛选出符合查询条件的第一条结果实例演示 sql查询结果只显示指定行数的数据方法