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 a covering index?
Why truncate is ddl command?
What are the new features of sql server 2012 reporting service?
Tell me what are cursors and when they are useful?
what is the different types of backups available in sql server? : Sql server database administration
What are scalar functions?
What is analysis service repository?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is PROJECTION Operation?
How can sql server instances be hidden? : sql server security
Explain subquery and state its properties?
What does it mean if @@cursor_row returns a negative number?
Can we use where clause in union?
How do I install only the client tools of sql server 2000?