INSERT INTO TABLE1(F_SPNM, F_BMNM, F_JYFS, F_XM1, F_XM2, F_XM3)
SELECT F_SPNM, F_BMNM, F_JYFS,
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS
HAVING F_RQ=(SELECT MAX(F_RQ) FROM HSSPRJZ)
SELECT F_SPNM, F_BMNM, F_JYFS,
round(F_JCSL * F_LSDJ,2),
round(F_JCSL * F_PJJJ,2),
round(F_JCYS, 2)
FROM HSSPRJZ WHERE F_RQ <='20031025'
GROUP BY F_SPNM, F_BMNM, F_JYFS
HAVING F_RQ=(SELECT MAX(F_RQ) FROM HSSPRJZ)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货