110,534
社区成员
发帖
与我相关
我的任务
分享
WITH T As (
SELECT ROW_NUMBER() OVER (ORDER BY abstime ASC) AS ROWID,
frequency
FROM N2_Data
)
SELECT frequency
FROM T
SELECT frequency,
(
select count(*) from n2_data
) as cnt
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY abstime ASC) AS ROWID, *
FROM N2_Data
) T
WHERE T.ROWID=1 OR T.ROWID%10000=0
SELECT *
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY EMPID ASC) AS ROWID, *, count(*) AS CNT
FROM EMPLOYEE
) T
WHERE T.ROWID=1 OR T.ROWID=100