在两表中联合查询,语句如下:
SELECT ID, ACCEPT_TIME, TYPE, AMOUNT, CURRENCY_CODE , STATUS, NOTE1
FROM
(
(SELECT DEPOSIT_ID ID , DEPOSIT_ACCEPT_DATETIME ACCEPT_TIME , 1 TYPE , DEPOSIT_AMOUNT AMOUNT , CURRENCY_CODE , STATUS, NOTE1
FROM JHF_DEPOSIT ) UNION
(SELECT WITHDRAWAL_ID ID , WITHDRAWAL_ACCEPT_DATETIME ACCEPT_TIME , -1 TYPE , WITHDRAWAL_AMOUNT AMOUNT , CURRENCY_CODE , STATUS, NOTE1
FROM JHF_WITHDRAWAL )
) CC
WHERE ACCEPT_TIME > ?
ORDER BY ACCEPT_TIME DESC
如果想显示第10条到第20条的信息,rownum应该怎样写呢?要求应该先按时间排序,然后再从中取数据,谢谢各位大侠!
SELECT ID, ACCEPT_TIME, TYPE, AMOUNT, CURRENCY_CODE , STATUS, NOTE1
FROM
(
(SELECT DEPOSIT_ID ID , DEPOSIT_ACCEPT_DATETIME ACCEPT_TIME , 1 TYPE , DEPOSIT_AMOUNT AMOUNT , CURRENCY_CODE , STATUS, NOTE1
FROM JHF_DEPOSIT ) UNION
(SELECT WITHDRAWAL_ID ID , WITHDRAWAL_ACCEPT_DATETIME ACCEPT_TIME , -1 TYPE , WITHDRAWAL_AMOUNT AMOUNT , CURRENCY_CODE , STATUS, NOTE1
FROM JHF_WITHDRAWAL )
) CC
WHERE ACCEPT_TIME > ?
ORDER BY ACCEPT_TIME DESC
如果想显示第10条到第20条的信息,rownum应该怎样写呢?要求应该先按时间排序,然后再从中取数据,谢谢各位大侠!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货