Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
- 11 Answers
- 29522 Views
- World Tech, Yardi Software, I also Faced
- E-Mail Answers
Answer Posted / sudheer gowlikar
Having clause Specifies a search condition for a group or
an aggregate. HAVING can be used only with the SELECT
statement. HAVING is typically used in a GROUP BY clause.
When GROUP BY is not used, HAVING behaves like a WHERE
clause.
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
what are constraints? : Sql server database administration
What are the differences between sql server and mysql.
What are the disadvantages of primary key and foreign key in SQL?
how can you check the level of fragmentation on a table? : Sql server administration
Explain the categories of stored procedure?
How to find out what is the default collation in a database?
What is user-defined multi-statement table-valued function?
Distinguish between nested subquery and correlated subquery?
What is join and name different type of joins?
What is the most common type of join?
How to rename databases in ms sql server?
How to round a numeric value to a specific precision?
Can we use trigger new in before insert?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What happens if you delete a table that is used by a view?
