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
What does COMMIT command do?
What is the difference between a local and a global temporary table?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
How to locate and take substrings with charindex() and substring() functions?
Show Practically Sql Server Views are updatable?
What is command parameter in ssrs?
What is an active database?
List down some advantages of sql stored procedure?
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain log shipping?
What are different types of collation sensitivity?
Describe how to use the linked server?
How can you hide the sql server instances?
Can you name some of the dml commands in sql?
how to overcome kernel isssues