Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5838 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
Is null in sql server?
What do you mean by sql server agent?
Write an sql query for deleting duplicate rows?
what are user defined datatypes? : Sql server database administration
Can we use pragma autonomous_transaction in trigger?
How to perform key word search in tables?
What is trigger in salesforce?
In what version of sql server were synonyms released?
what method you can use to reduce the overhead of Reporting Services data sources?
What are the different subsets of sql?
How do I uninstall sql server 2014?
Can you explain what are commit and rollback in sql?
State the difference between local and global temporary tables?
What security features are available for stored procedure?
How connect excel to sql server?
