where is used when no group by functions are used whereas having is used

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

Question Posted / aravind

Answer Posted / aravind

where is used when no group by functions are used whereas
having is used when group functions are used

Is This Answer Correct ?

3 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Explain some stored procedure creating best practices or guidelines?

872

How can I track the changes or identify the latest insert-update-delete from a table?

915

Tell me in brief how sql server enhances scalability of the database system?

940

What is sql server profiler?

957

Explain optimistic and pessimistic concurrency?

930

Can two tables share the same primary key?

858

What is the cartesian product of table?

932

Explain collation?

1005

How to use transact-sql statements to access the database engine?

999

What do you mean by an execution plan?

1055

What is RMS migrations?

2088

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1100

How does stuff differ from the replace function?

960

Explain what is raid and what are different types of raid levels?

954

What is built-in/administrator?

958