What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / guest
Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.
| Is This Answer Correct ? | 68 Yes | 4 No |
Post New Answer View All Answers
Is natural join and equi join same?
What is the difference between a "where" clause and a "having" clause?
What is difference between sql and sql server?
What does truncate do?
Is sql server free?
Why main is user defined function?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How can delete duplicate records in cte in sql server?
What is pessimistic concurrency?
Mention the different types of replication in sql server.
Do you know the cursor optimization tips?
When would you prefer to have a minimum number of indexes?
What are the different types of cursor?
How do I find information about the install locations for the various instances running on a computer?
Does view occupy space?