Home....
Developer Network >> Other Programming >> Database

GROUP BY returns zero rows...

I have an sql query that looks like this :
SELECT table.ID , AVG(*) as AVERAGE , ... , ... from table WHERE X > 200 GROUP BY table.ID ORDER BY AVERAGE

this query qorks great...
everytime there's more than one row in the table, but when theres only one row, it returns zero rows!
I think this is because of the GROUP BY Statement, but im not sure...
How can I prevent this from happening??
[421 byte] By [gilly914] at [2007-11-20 10:31:33]
«« default function in a dll to handle a non-existant function call?
»» TWo singelton implementations which one is better...
# 1 Re: GROUP BY returns zero rows...
can u explain ur query like ID is primary key? and ON WHICH COLUMN YOU WANT AVERAGE?
Waqas_Badar at 2007-11-9 13:45:29 >
# 2 Re: GROUP BY returns zero rows...
It would help if you posted a more complete query. It's obvious that you've removed important things such as joins (or you wouldn't be grouping on an ID.)
andreasblixt at 2007-11-9 13:46:30 >
# 3 Re: GROUP BY returns zero rows...
everytime there's more than one row in the table, but when theres only one row, it returns zero rows!
I think this is because of the GROUP BY Statement, but im not sure...
How can I prevent this from happening??

'select' returns Zero rows when 'Where' or 'Having' statements doesn't
find some row.
hensa22 at 2007-11-9 13:47:29 >
Other Programming
Database

Other Programming

All Classified

Other Programming New Topic

Other Programming Hot Topic