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
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is wrong with sql server client libarary dll, ntwdblib.dll?
Does sql server 2016 have ssms?
What is sub-query in sql server? Explain its properties.
how to trace the traffic hitting a sql server? : Sql server database administration
Tell me something about security and sql azure?
What are the steps you will take to improve the performance of a poor performing query?
Define Wed Edition in SQL Azure?
What is sql sandbox in sql server?
What is the security model used in sql server 2005?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How to create sub reports?
if no size is defined while creating the database, what size will the database have? : Sql server administration
How to create an inline table-valued function?
What is a select query statement in ms sql server?