SELECT * FROM (SELECT ID, NAME, X, Y, Z, ZOOM, PERSONAL, ARCHIVED, rownumber() over(order by ID desc) as ROW FROM ISUPERMAP.POSITION WHERE ID IN(SELECT DISTINCT(ID) FROM ISUPERMAP.POSITION_TAG WHERE TAG IN({0}))) as TEMP where TEMP.ROW >= ? and TEMP.ROW < ?
SELECT *
FROM (SELECT ID, NAME, X, Y, Z, ZOOM, PERSONAL, ARCHIVED, row_number() over(order by ID desc) as ROW
FROM ISUPERMAP.POSITION
WHERE ID IN(SELECT DISTINCT(ID)
FROM ISUPERMAP.POSITION_TAG
WHERE TAG IN({0}))) as TEMP
where TEMP.ROW >= ? and TEMP.ROW < ?还有这一句 WHERE TAG IN({0})) tag是什么格式的?