How to use 'HAVING' without 'GROUP BY' what's wrong with this QUERY?

Question

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) Please do guide in Oracle and in SQL. Thanks in advance

Syed Arbab Ahmed · Answer

1-There are values 2-That's the thing that I don't want to use 'GROUP BY' as from this website i found that ...the HAVING clause may or may not include the GROUP BY clause. The syntax for HAVING is... http://www.1keydata.com/sql/sqlhaving.html the query is not giving any syntax error i want to know is there any logical error in that.

Syed Arbab Ahmed · Answer

I have found that 'HAVING' without 'GROUP BY' can be used  ...the HAVING clause may or may not include the GROUP BY clause. The syntax for HAVING is....  http://www.1keydata.com/sql/sqlhaving.html so I was trying to practice that.

Kalyan Vedantam · Answer

Hi The result of your query is just one row with a single value which is the sum of all the Account_Type. Now if this value is not You need to select an Id or some other field associated with the Account_Type and do a group by on that field. for e. let us say you have an Id field your query will be: SELECT Id SUM(ACCOUNT_TYPE) FROM TBLCUSTCHANNEL Group By Id HAVING SUM(ACCOUNT_TYPE)

Koteswararao Mallisetti · Answer

in this case we use where clause why u go for havaing  the having is use along with group bu only

How to use 'HAVING' without 'GROUP BY' , what's wrong with this QUERY?