How to use 'HAVING' without 'GROUP BY'?

arbab · October 14th, 2010, 07:24 AM

Hi!

'Having' can be used without 'Group by' as well, table has the data but this query is not returning any answers is there anything wrong with this query?

SELECT SUM(ACCOUNT_TYPE)
FROM TBLCUSTCHANNEL
HAVING SUM(ACCOUNT_TYPE) <=10

Please do guide in Oracle and in SQL.

Thanks in advance

joefawcett · October 15th, 2010, 03:31 AM

If the parser doesn't complain about syntax errors then it looks fine (but I'm no expert on PL/SQL).
Can you give some DDL and DMl to create and populate a table with some sample data so we can try this ourselves?

Gerecs · March 9th, 2011, 04:07 AM

I think, if the data exist, your query should be good

arbab · March 9th, 2011, 07:33 AM

There was a logical error in my query as I wanted to use sum function for those account_type whose values are less than or equal to 10,

but the above query actually doing sum with all records of
account_type, and answer was not showing because there sum was above 10.

So either I have to use subquery or I don't know how much I can play with this query to have my desired result.