what is difference between having and where clause ?
- 3 Answers
- 4974 Views
- I also Faced
- E-Mail Answers
Answer Posted / raju
Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How to Update from select query in sql server?
How to get @@error and @@rowcount at the same time?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What Are the Main Features of SQL Azure?
What is ms sql server service broker?
What is the sql server 2000 version number?
Explain what are the events recorded in a transaction log?
What do you understand by the analysis services in sql server?
Can we add a cpu to sql server?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How do you rebuild an identity column?
What are scalar functions in sql?
