you can write a SQL such thatthe 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
ok, thank you. but
i am using java with a oracle database. the rank method, is it a standard sql function or only provided by MSsql+ASP.net?
Huasing Association 1999 - 2013