What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 26979 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
Why do we need normalization?
Explain system views?
Do you know the different ddl commands in sql?
What is federation member?
What is cursors?
Sql server reporting services vs. Crystal reports.
What happens if strings are casted into wrong code pages in ms sql server?
What is the difference between cartesian product and cross join?
What happens if null values are involved in string operations?
How to move database physical files in ms sql server?
Where in ms sql server is ’100’ equal to ‘0’?
Explain can you implement data mining in ssrs?
System requirements for sql server 2005 express edition?
Why are views required in the sql server or in any other database?
What is inner join? Explain with an example?
