SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ID) AS sira FROM tablo_adi ) AS tablo WHERE Durum='1' AND sira BETWEEN 400 AND 600