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

1-There are values <= so there should come some rows.

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.

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.

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 <= 10 you will not get back anything.
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) <=10

in this case we use where clause why u go for havaing ,

the having is use along with group bu only