SysBlog

Problem: u tablici (polja id i naziv) imamo 10 imena… nas zanimaju imena od 6-tog reda nadalje

Pero, Mirko, Ana, Mate, Boris, Zoran, Ivana, Željko, Miro, Ivica

Rješenje:

SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY id ASC) AS rownumber,
    ime
  FROM tbl_imena
) AS dtbl_privremena
WHERE rownumber >= 7
rezultat: Ivana, Željko, Miro, Ivica