Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Sql: Top 5
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Sql: Top 5
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
ngaisteve1 View Drop Down
Groupie
Groupie
Avatar

Joined: 26 December 2002
Location: Malaysia
Status: Offline
Points: 169 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ngaisteve1 Quote  Post ReplyReply Direct Link To This Post Topic: Sql: Top 5
    Posted: 21 November 2003 at 8:57pm
This is about sql. I know that to display first 5 (highest hit)query, I need to use TOP 5 but I encounter a problem where two records has similar count. Eg,

Apple = 4
Orange = 7
Banana = 3
Mango = 3
Coconut = 6
Pineapple = 5

The result come out is 6 records instead of 5 because banana and mango are same. Anyway, I can solve this problem. How do you guys usually deal with this problem rarely happens I think? Just display 4 or still display 5 records but the last one is random basis or how.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 21 November 2003 at 10:16pm
I leave it at the number defined unless critical that noone is left out I'd create a SP to dynamically get another number.
Blog | MPG Tracker
Back to Top
Bluefrog View Drop Down
Senior Member
Senior Member


Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bluefrog Quote  Post ReplyReply Direct Link To This Post Posted: 24 November 2003 at 6:42am
I'd ORDER BY and just eliminate something.
Renegade Minds - Guitar Software Slow Down Music
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.