Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Sql Record Select

2 Posts 2 Posters 0 Views 1 Watching

S Offline
S Offline
sivaprakas

wrote on last edited by

#1

hi anyone give query to select first 4 records , select last 4 records , select next 4 records and select previous 4 records in MSSqlServer
E 1 Reply Last reply

0
S sivaprakas

hi anyone give query to select first 4 records , select last 4 records , select next 4 records and select previous 4 records in MSSqlServer
E Offline
E Offline
Elina Blank

wrote on last edited by

#2

More info needed: your result recordset must be ordered by something? Check this " Row_Number() over"

Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O
1 Reply Last reply

0

Log in to reply