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
Printable View
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
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
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