如下的SQLSERVER语句:
SELECT TOP 100 PERCENT INFOID, INFOTITLE, CHANNELID, CONVERT(char(10),
INFOCREATEDTIME, 110) AS LASTDATE, CONVERT(char(10), INFOCREATEDTIME, 110)
AS INFOCREATEDTIME
FROM INFORMATION
WHERE (1 = 1) AND (CHANNELID = 'id7hYccwDsCWKGTPIr') AND (ISSHOWN = 1)
ORDER BY INFOCREATEDTIME DESC怎么把以上语句转换成ORACLE.求助大家帮办忙.
SELECT TOP 100 PERCENT INFOID, INFOTITLE, CHANNELID, CONVERT(char(10),
INFOCREATEDTIME, 110) AS LASTDATE, CONVERT(char(10), INFOCREATEDTIME, 110)
AS INFOCREATEDTIME
FROM INFORMATION
WHERE (1 = 1) AND (CHANNELID = 'id7hYccwDsCWKGTPIr') AND (ISSHOWN = 1)
ORDER BY INFOCREATEDTIME DESC怎么把以上语句转换成ORACLE.求助大家帮办忙.
to_date(INFOCREATEDTIME,'YYYY-MM-DD') AS LASTDATE,
to_date(INFOCREATEDTIME, 'YYYY-MM-DD') AS INFOCREATEDTIME
FROM INFORMATION
WHERE (1 = 1) AND (CHANNELID = 'id7hYccwDsCWKGTPIr') AND (ISSHOWN = 1)
and row num<100
ORDER BY INFOCREATEDTIME DESC
INFOCREATEDTIME AS LASTDATE,INFOCREATEDTIME
AS INFOCREATEDTIME
From INFORMATION
WHERE (1 = 1) AND (CHANNELID = 'id7hYccwDsCWKGTPIr') AND (ISSHOWN = 1) And rownum<101
ORDER BY INFOCREATEDTIME Desc
好像有2点错误:
SELECT PERCENT INFOID, INFOTITLE, CHANNELID,
----->修正:
SELECT INFOID, INFOTITLE, CHANNELID, and row num<100
----->修正:
and row num<=100
INFOCREATEDTIME AS LASTDATE,INFOCREATEDTIME
AS INFOCREATEDTIME
From INFORMATION
WHERE (1 = 1) AND (CHANNELID = 'id7hYccwDsCWKGTPIr') AND (ISSHOWN = 1)
ORDER BY INFOCREATEDTIME Desc ) where rownum<101