请教使用SQL如果数据库里有很多数据, 由于内存有限, 每次我只取固定数目的数据, 比如每次取100行, 下一次再取接着的100行, 应该怎么写? 谢谢.
table name: table
Select name from table
?
?
?
you can write a SQL such that
the top 100 records are return by using an estimated cutoff.
if you are using MSSQL+ASP.NET, you can query with a method rank(int numberofrecords) or somthing similar. not sure about other databases/data access technology
if you are using MSSQL+ASP.NET, you can query with a method rank(int numberofrecords) or somthing similar. not sure about other databases/data access technology
Freedom is slavery.
Ignorance is strength.
Huasing Association 1999 - 2013