Where clause is used prior the grouping of data, where as Having is used a

What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?

Question Posted / saisri

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

Please Help Members By Posting Answers For Below Questions

Can a database be shrunk to 0 bytes, if not, why?

1159

what are the Prerequisites for Replication?

11441

List out the difference between union and union all in sql server?

1037

Is it safe to delete log files?

970

Do you know nested transaction?

998

What is normalization? Describe its different types.

1151

What is an execution plan? How would you view the execution plan?

1127

How to list all login names on the ms sql server?

1182

What are the basic features of a trigger in ms sql server?

1264

Explain transaction isolation levels in sql server?

1181

What do you understand by hotfixes and patches in sql server?

1028

How to integrate the ssrs reports in application?

1039

Why should one not prefix user stored procedures with ‘sp_’?

1097

Does index speed up select statements?

1072

SQL Server Architecture ?

2518