you can write a SQL such that
所在版块：社会百科 发贴时间：2002-12-20 10:17  评分:

用户信息
复制本帖HTML代码
高亮: 今天贴 X 昨天贴 X 前天贴 X 
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
.
欢迎来到华新中文网，踊跃发帖是支持我们的最好方法!

War is peace.
Freedom is slavery.
Ignorance is strength.
　相关帖子 我要回复↙ ↗回到正文
请教使用SQL － 我心为谁动 　2002-12-20 10:01 (170 bytes , 458reads )
这个问题挺有意思,我们研究研究 － 恐龙特急克塞号 　2002-12-20 11:14 (341 bytes , 337reads )
enn... － 我心为谁动 　2002-12-20 12:10 (104 bytes , 227reads )
其实我没试过:) － 恐龙特急克塞号 　2002-12-20 13:17 (0 bytes , 157reads )
you can write a SQL such that － SmellsLikeTeenSpirit 　2002-12-20 10:17 (222 bytes , 216reads )
ok, thank you. but － 我心为谁动 　2002-12-20 10:23 (121 bytes , 206reads )
No need ASP.NET lah. － Flying 　2002-12-20 10:55 (76 bytes , 197reads )
hmm....cursor, another advanced non-SQL thingy? － SmellsLikeTeenSpirit 　2002-12-20 11:37 (0 bytes , 189reads )
dynamic sql － 恐龙特急克塞号 　2002-12-20 13:18 (0 bytes , 152reads )
can you demonstrate how to do that? thank you － 我心为谁动 　2002-12-20 11:06 (0 bytes , 174reads )