|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 13th, 2004, 12:07 AM
|
|||
|
|||
|
Oracle GROUP BY equivalent to MySQL
I use this statement on a CGI script for a MySQL DB
"SELECT a.app_name, COUNT(*) AS counttimes, c.co_name, b.user_app_id, a.app_solution FROM isv_app a, isv_user b, isv c WHERE a.app_id=b.user_app_id AND a.app_co_id=c.isv_id group by b.user_app_id ORDER BY counttimes DESC" and it works fine, however, I use the same script but this time round is cater to work on an Oracle DB and somehow an error "ORA-00937 not a Single-Group group function" was generated. Can someone pls advise me how to solve this? I'm not an expert in Oracle, really need help here...
|
|
#2
July 13th, 2004, 10:12 AM
|
|||
|
|||
|
First off, use code tags. If you don't know how read the FAQ.
As I read your SQL there is nothing wrong with it. Are you sure this statement is causing the 937 error? Reason: 937 errors only happen when there is a GROUP BY clause, and you do not have one in that statement.
|
|
#3
July 15th, 2004, 10:35 PM
|
|||
|
|||
|
Code:
SELECT a.app_name, COUNT(*) AS counttimes, c.co_name, b.user_app_id, a.app_solution FROM isv_app a, isv_user b, isv c WHERE a.app_id=b.user_app_id AND a.app_co_id=c.isv_id group by b.user_app_id ORDER BY counttimes DESC You are not grouping by what you are selecting (ie a.app_name, c.co_name, b.user_app_id, a.app_solution).
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Oracle GROUP BY equivalent tp MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
