what is difference between having and where clause ?
Answer Posted / raju
Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is cte (common table expression)?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Name and describe few console utilities for ssrs?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Explain syntax for disabling triggers?
Explain where clause?
what are the types of indexes? : Sql server database administration
How would you use user_constraints table in DB?
Difference between DELETE and TRUNCATE?
How do I find the port number for sql server?
Can sql servers link to other servers like oracle?
What are the hotfixes and patches in sql server?
What is left outer join in sql server joins?
What type of locking occurs during the snapshot generation? : sql server replication
define and explain the differences between clustered and non-clustered indexes.