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
What is transaction server implicit?
How to change parameter value inside the report?
What are key constraints?
What is optimization and its types?
What are the advantages of using stored procedures in sql server?
What do you understand by sql server agent?
What are data files?
Explain difference between cross join and full outer join?
Which Model uses the SET concept
What it means to be triggered?
What is the difference between char, varchar and nvarchar?
What are the different types of columns types constraints in the sql server?
Where sql server usernames and passwords are stored in a sql server?
Explain what is meant by replication of database?
What is PROJECTION Operation?