What is the difference between having and where clause?
- 4 Answers
- 9701 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinay singh
We can't use Where clause with aggregate function and Having
clause always use with aggregate function.
**Vinay Singh
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How would you use user_constraints table in DB?
What is log cache in sql server?
how will add additional conditions in sql?
What happens if strings are casted into wrong code pages in ms sql server?
Is INSTEAD OF trigger directly applicable to Table ?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is the default sql server instance name?
What is the boxing and unboxing concept in .net?
What is bcp? When does it use?
How to use "begin ... End" statement structures in ms sql server?
What are the difference between clustered and a non-clustered index?
What is difference between clustered index and non clustered index?
How to Check if table exists in sql server?
What is user-defined scalar function?
