Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Where and Having Clause
- 7 Answers
- 30442 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 the syntax for FETCH in DB2 ?
what is the sqlcode -501
What is innodb buffer pool?
What kind of database is db2?
Which isolation level provides highest data integrity?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a db2 tablespace?
Before you give the explain statement, what are the prerogatives?
What is a collection in db2?
How do I add a column to a table in db2?
Explain packages.
What is image copy in db2?
what are bind concepts in db2 cobol?
What is db2 connect?
How will you return the number of records in table?
