Top Ten List

Results 1 to 2 of 2

Thread: Top Ten List

  1. #1
    Join Date
    Dec 1969

    Default Top Ten List

    I&#039;m pretty new to ASP, so forgive me..hehe<BR>The db I&#039;m using is Access...<BR>I have a table called Links with a primary id of LinkID, and I have a field called hit_count that is holding a number of how many times a link has been clicked. On my main grid page there is a form called topten that have the LinkID, Title and hit_number fields in it... I just need to populate it with the top ten records with the highest hit_number value, it should probably be a sql entry but I can&#039;t figure out the query...any ideas? <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Top Ten List

    SELECT TOP 10 * FROM Links ORDER BY hit_number DESC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts