 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / General DB Topics / General DB Topics / February 2005Way to get most occurences in database
Is there a function to get the number of most occurences in a database? Like, in a table, if i have values: 8 8 8 8 3 3 21 17 8 8 3 4 Is there a way that it can return 8 since it's the most occured number? MySQL is the database > Is there a function to get the number of most occurences in a database? > Like, in a table, if i have values: [quoted text clipped - 13 lines] > > Is there a way that it can return 8 since it's the most occured number? Being that this is homework, look up COUNT, MAX and GROUP BY. > Is there a function to get the number of most occurences in a database? > Like, in a table, if i have values: [quoted text clipped - 13 lines] > > Is there a way that it can return 8 since it's the most occured number? Actually, it's not homework at all, and if you are implying that I am trying to get the answer to a problem in one of my classes then you need to not ASSuME. Anyways, thanks for the info, I got the problem fixed. > Being that this is homework, look up COUNT, MAX and GROUP BY. > [quoted text clipped - 15 lines] >> >>Is there a way that it can return 8 since it's the most occured number? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.