This function started in sql server 2005 onwards.
eg:
selectyou will get the records with each row having a row number like this:
1 371178
2 371179
3 371181
4 371182
This is good when you want in between rows; lets say you want rows between 125 and 226 rows.
Though you can use between but between actually searches the data between the mentioned columns on which we are searching/filtering.
No comments:
Post a Comment