oracle 取日期最大的那条记录
需求:每天消费大于3000的用户,如有多条,取最近一条
CREATE TABLE T_DEFINE_2(
cus_id VARCHAR2(100),
cdate VARCHAR2(100),
finalPrice NUMBER(10));
INSERT INTO T_DEFINE_2 VALUES ('DEFINE','20160301',500);
INSERT INTO T_DEFINE_2 VALUES ('DEFINE','20160301',10000);
INSERT INTO T_DEFINE_2 VALUES ('DEFINE','20160302',500);
INSERT INTO T_DEFINE_2 VALUES ('DEFINE','20160302',200000);
INSERT INTO T_DEFINE_2 VALUES ('DEFINE','20160303',500);
INSERT INTO T_DEFINE_2 VALUES ('DEFINE','20160303',3000);
INSERT INTO T_DEFINE_2 VALUES ('ECHOS','20160303',500);
我只写了一半.....不知道多条数据,怎样获取最近日期
SELECT T2.CUS_ID, T2.CDATE, SUM(T2.FINALPRICE)
FROM T_DEFINE_2 T2
GROUP BY T2.CUS_ID, T2.CDATE
HAVING SUM(T2.FINALPRICE) >= 3000
期望结果:
1 ECHOS 20160303 3000
2 DEFINE 20160303 3500