MS SQL’de satır numarasını alma

1
2
3
4
5
6
7
SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY id ASC) AS rownumber,
    id, ilceAdi
  FROM Ilce
) AS foo
WHERE rownumber = 5

Leave a Reply

Please type the characters of this captcha image in the input box

Please type the characters of this captcha image in the input box