Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between group and having
give an example with query and sample output
- 7 Answers
- 9895 Views
- I also Faced
- E-Mail Answers
Answer Posted / pawan378
in addition to the above correct answers ..
Having Clause allows to add conditions using functions
Ex: COUNT(*) > 2
at on the same phrase of the query. this will be basically
to avoid sub queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is the difference between inner join and equi join?
What is history table in sql server?
can a table be moved to different filegroup? : Sql server administration
What is difference between index seek vs. Index scan?
How to loop through result set objects using mssql_fetch_array()?
How to insert multiple rows with one insert statement in ms sql server?
What is the chart in report?
Are semicolons required at the end of sql statements in sql server 2005?
What's the information that can be stored inside a bit column?
How to display a past time in days, hours and minutes?
Define union, union all, minus, intersect?
What are extended events in sql server?
If a table does not have a unique index, can a cursor be opened on it?
Tell me what are the advantages of using stored procedures?
