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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-29 : 12:09:43
|
| Higgie writes "Hello,i have the following problem.I have a database and i will select the first 10 rows of it.The limit statement from mysql doesnt work on odbc i thing.I search for other commands and found the "SELECT TOP 10 * FROM ..." Statement. But this only select the first 10 rows. What have i do when i will select the rows 10-20? I tried this:"SELECT top 2 * FROM int_log where id not exists in (select top 2 * from int_log)" but there my odbc send an error that this is only 4 one field not 4 a hole row.Please help me i worked very hard on my projekt and cant finish it with this problem.thx 4 help.btw sry 4 my bad english :)" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
|
|
|
|
|
ODBC+Access97+php 