Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
How to use 'HAVING' without 'GROUP BY' , what's wrong with this QUERY?
Syed Arbab Ahmed
Oct 14 2010 8:17 AM
2.6k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
SQL tables for a chat app
Like usage in sql sentence