Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30158 Views
- IBM, iFlex, I also Faced
- E-Mail Answers
Answer Posted / narendra
Both are used to filter the rows but
where is used to filter the rows on single row functions and
having is used to filter the rows on group functions or aggregate functions.
one more thing i would like to mention is
having can be used without group by
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is bind in db2?
What is iseries database?
What is load replace in db2?
What is the maximum No of rows per page?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What are host variables in db2?
What are the various data types available in db2?
What is the difference between drop table and delete table?
How would you find out the total number of rows in a db2 table?
Explain about dbrm.
Explain about open switch business continuity software?
What is meant by dclgen?
What is dbrm? What it contains?
What is the syntax for creating a table in the db2 database?
Why do we need reorg in db2?
