SysBlog

Zanima nas koji je po redu rezultat sa id-jem 17 kad pozovemo query “SELECT mojID, mojNaslov FROM tbl_tablica ORDER BY mojID ASC”

SELECT * FROM (
 SELECT
 ROW_NUMBER() OVER (ORDER BY mojID ASC) AS rownumber,
 mojID, mojNaslov
 FROM tbl_tablica
) AS test
WHERE mojID=17

Navedeni query daje koji je po redu rezultat gdje je mojID=17 unutar queryja SELECT mojID, mojNaslov FROM tbl_tablica ORDER BY mojID ASC