求请教：ORACLE 按日期求最后一次销价，日期字段是VARCHAR

Question

**TABLE A **
DJBH SPID JG
1001 001 3.00
1001 002 4.00
1002 001 5.50
1002 002 6.50
TABLEB

DJBH RQ
1001 2022-01-02
1002 2022-01-06

求最后一后销售价
SPID JG RQ

Answer 1

SELECT SPID, JG ,RQ FROM 
(select A.*,B.RQ ,
ROW_NUMBER() OVER(PARTITION BY A.DJBH ORDER BY RQ DESC) RN
 from A, B WHERE A.DJBH=B.DJBH) T
WHERE T.RN=1