 OT: need SQL help, asking the gurus ... |
|
|
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
|
| SirAndy |
  Jul 22 2004, 12:30 PM
Post
#1
|
|
Resident German  Group: Admin Posts: 42,234 Joined: 21-January 03 From: Oakland, Kalifornia Member No.: 179 Region Association: Northern California  |
ok, here's the problem:
let's say i have a table with 2 rows like the example below. in the second row, i have a integer status value (iStatus). i need a query that allows me to find the value that occurs the most in the table, in the example below, that would be "3". i'm not interested in how many 3s there are, all i need is to find out which iStatus value shows up the most in the table ... (IMG:style_emoticons/default/pray.gif) Attached image(s) 
|
   |
 
|
  |
Replies
| lapuwali |
Jul 22 2004, 12:36 PM
Post
#2
|
|
Not another one! Group: Benefactors Posts: 4,526 Joined: 1-March 04 From: San Mateo, CA Member No.: 1,743  |
Oracle, MySQL, SQLServer, DB2, etc? It will make a difference. There is no single "SQL".
Just off the top of by non-guru head, I'd say you're looking at using MAX(COUNT(*)), probably with a sub-select, but I can't give you exact syntax w/o knowing which SQL, and I only know MySQL and Oracle (and I don't know Oracle well). |
|
|
|
Posts in this topic
SirAndy OT: need SQL help Jul 22 2004, 12:30 PM
SirAndy ... Jul 22 2004, 12:40 PM Cloudbuster select top 1 count(iStatus) as StatCount, sDescrip... Jul 22 2004, 01:18 PM SirAndy <... Jul 22 2004, 02:02 PM |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 1st July 2025 - 08:08 AM |
Invision Power Board
v9.1.4 © 2025 IPS, Inc.