What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / vivek kumar
where clause is used for conditional retriving but having
clause is used to test some condition on the group with the
help of aggregate function.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is normalization and denormalization in sql server?
What are information schema views?
What is the default Port No on which SQL Server listens?
What is an example of a foreign key?
What are the limitations/drawbacks or ssrs 2008 r2?
What are the new features of sql server 2012 reporting service?
What do you understand by mirroring and mention the advantages of the mirroring?
Do you know what are acid properties?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is primary key, unique key, and foreign key?
Why would you call update statistics?
What do you understand by replication in sql server?
What is spatial and temporal data?
What happens if null values are involved in boolean operations?
How many types of objects are there?