Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29663 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / manisha
Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.
| Is This Answer Correct ? | 22 Yes | 9 No |
Post New Answer View All Answers
What are the new features in sql server 2016?
What is report rendering ?
What are information schema views?
What is the maximum number of index per table?
How to execute stored procedure and set temp table in sql server?
How many partitions a clustered index has by default in sql server 2012?
What is NOT NULL Constraint in sql server 2012?
Explain about SQLOS?
What is self contained scalar sub query?
Explain what are the restrictions while creating batches in sql server?
What encryption security is available in sql azure?
What is the use of toad or sqldbx.?
Tell me when is the update_statistics command used?
Explain the disadvantages of cursors?
How to create a store procedure with encryption?
