Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mckay
Starting Member
8 Posts |
 Posted - 2006-02-08 : 01:21:45
|
| hi, is there any fuction in Sql Server that are similar like function 'limit' in MySql?thxMckay |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-08 : 01:42:02
|
| Hi, You can use Select Top n * from tablename which is equivalent to LIMIT 0, row_countbut there is nothing like LIMIT 3,4 (getting 4 rows starting from 4th)for that you need to have an identity coumn in your table then use the IDENTITY column to get the necessary rows. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
limit function?