As per my knowledge WHERE is for conditional retrieving but we cann'

What is the difference between HAVING clause and the WHERE
clause?

Question Posted / srinivas

Answer Posted / srinivas

As per my knowledge WHERE is for conditional retrieving but
we cann't use Average Functions in WHERE clause.
HAVING clause can include AVG Functions.

Is This Answer Correct ?

20 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are the events recorded in a transaction log?

981

What is primary key and example?

930

Define full outer join in sql server joins?

956

What are views in ms sql server?

1058

How to find the second highest salary of an employee?

1158

What do you mean by the term 'normalization'?

1178

What is user defined datatypes and when you should go for them?

999

What are ddl (data definition language) statements for tables in ms sql server?

1080

What is sql server transaction log file?

1036

What were the latest updates to SQL Azure service?

111

How do you trace the traffic hitting a sql server?

1122

What is the openxml statement in sql server?

1052

what are the new features introduced in sql server 2000? : Sql server database administration

899

What is collation sensitivity? Explain different types.

994

What is difference between join and natural join?

943