Do the following,

set rowcount 5
select * from tablename order by fldTimes desc
set rowcount 0


------------
Ray Miao at 1/25/2002 1:26:09 PM

set rowcount 5

your query ...

set rowcount 0




------------
Amir at 1/25/2002 11:24:52 AM

I have a database which has a field called fldTimes. basically this field records the number of hits a file gets. How can I choose the most 5 popular files with the greatest hits. Thanks