Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5670 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhiman
Where clause is used to check for the condition- select rows
& restrict rows and where comes before having clause whereas
Having is clause that is created to utilize all the group
functions (sum,avg,min,max,count) and is used for select or
restrict a particular group.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between group by clause and having clause in SQL?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What do you mean by an execution plan?
What is the difference between a stored procedure and a user defined function?
what is memory-optimized nonclustered indexes
Can we use max in where clause?
Tell me what is the significance of null value and why should we avoid permitting null values?
How to return the date part only from a sql server datetime datatype?
How does using a separate hard drive for several database objects improves performance right away?
Explain Capacity planning to create a database? and how to monitor it?
How do you implement session management in SQL Server mode?
what is the main function of a query parameter?
How to create sub reports?
Do you know the cursor types?
What do you mean by collation recursive stored procedure?
