What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / senthil kumar t
Where clause is used for conditional retreiving from the
table and also aggregate functions can be used in where
clause. Having clause will be used for the recordset this
also supports the aggregate functions
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
How to declare and use cursor variables?
What is autocommit mode in sql server?
How to return the date part only from a sql server datetime datatype?
What is the most common type of join?
How to insert and update data into a table with "insert" and "update" statements?
How much space does sql server 2016 take?
What are the new scripting capabilities of ssms? : sql server management studio
Explain collation?
Explain trigger and its types?
What is normalization? What number of normalization shapes are there?
Describe triggers features and limitations?
How to invoke a trigger on demand?
explain the storage models of olap? : Sql server database administration
Explain the difference between HTTP and HTTPS in database?
What is the difference between update lock and exclusive lock?