list top

Results 1 to 2 of 2

Thread: list top

  1. #1
    Join Date
    Dec 1969

    Default list top

    Table [FavouriteFood]<BR><BR>Field1 FavouriteFoodID<BR>Field2 MemberID<BR>Field3 FoodName<BR>Field4 Order (rating in 1-5 5=&#062;top1, 4=&#062;top2, 3=&#062;top3, 2=&#062;top4, 1=&#062;top5)<BR><BR>What is need to show is list the top50 FoodName<BR><BR>thank you

  2. #2
    Join Date
    Dec 1969

    Default RE: list top

    SELECT TOP 50 foodname ORDER BY foodRating DESC<BR><BR><BR>

Posting Permissions

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