11

-- sql语句
select top 8 PSAM_TTC AS POS_TTC,OILTIME AS TIME,GUNNO AS NZN,OILNO AS G_CODE,
QTY AS VOL, PRICE AS PRIC, PRICE AS PRC, MONEY AS AMN, PUMPQTY AS V_TOT,
CARDNO AS ASN, CARD_TYPE AS C_TYPE,OILTIME as AddTime,
DateDiff(S,'1970-01-01 00:00:00',OILTIME) as AddID
from dbo.TrdTrade

查询条件: where GUNNO={0} AND OILTIME >'{1}'
查询添加: where OILTIME>
排序条件: order by OILTIME