Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between having and where clause ?
- 3 Answers
- 5717 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
According to you what goes into making the best database administrator? : sql server database administration
Explain transaction server implicit?
How to execute a sql statement using odbc_exec()?
How to check if stored procedure is running in sql server?
What is the order in which the sql query is executed?
Tell me the difference between clustered and non-clustered index?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is db stored procedure?
Explain the difference between delete,drop and truncate in SQL Server?
What command do we use to rename a db, a table and a column?
What is temporal table?
What is cdc in sql server?
What do you mean by data integrity?
How to resolve the orphan use problem? : sql server security
When would you prefer to have a minimum number of indexes?
