hi i wanna ask... we can use LIMIT in our MySql database. means we can fetch number of records as our need like : select * from table LIMIT 0,10 this query will fetch only 10 records but now my question is this that can we use this kind of query with MS Access OR MS SQLServer ??? if yes then ?? or if there is any other way to do this ... please tell me. thanks for ur support shahid
SQLServer has a similar capability with "SET ROWCOUNT 10"
It's not exactly the same, and there's no OFFSET that I know of.
