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 |
|
futi
Starting Member
2 Posts |
 Posted - 2007-07-19 : 03:14:58
|
| hi everybody. i wanna to limit my query and i dont know how i complete this. For example; i wanna display query from 3 to 10. In mysql, i did it : "SELECT * FROM TABLENAME LIMIT 3,10" but i couldnt in MSSQL. By the way, i use SQL Server Enterprise Manager. And version 8.0 and I don't sure my sql server is 2000. thanx |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
futi
Starting Member
2 Posts |
Posted - 2007-07-19 : 06:58:30
|
| thanx but this doesnt solve my problem. if you do this please help me. first link couldnt help me, second is a bit confused. |
 |
|
|
|
|
|
how i limit my query?