Day 6 Of Learning
Great work Jake
SELECT * FROM Railway
WHERE
[Payment Method] = 'Credit Card'
AND [Departure Station] = 'London Kings Cross'
ORDER BY [Transaction ID]
OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY;
It's show 5 rows skipping first 10.
Great work Jake
SELECT * FROM Railway
WHERE
[Payment Method] = 'Credit Card'
AND [Departure Station] = 'London Kings Cross'
ORDER BY [Transaction ID]
OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY;
It's show 5 rows skipping first 10.