What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / saisri
Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Can we add a cpu to sql server?
Explain about Normalization?
Explain “row_number()” in sql server with an example?
What are the new data types are introduced in sql 2000?
Is there any difference between primary key and unique with the not null condition?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What are the underflow and overflow behaviors on float literals?
Do you know what are the properties of the relational tables?
Explain differences between web edition and business edition?
Difference between Logical Page and Physical Page in SSRS.
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is the user of Primary key?
How to return the second 5 rows in ms sql server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What are the different kinds of ssrs reports?