WHERE is for conditional retrieving and having is using group of records

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

Question Posted / chandra kanth

Answer Posted / chandra kanth

WHERE is for conditional retrieving and having is using
group of records

Is This Answer Correct ?

13 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is difference between index and primary key?

1102

What are number line correlation administrators will use while working with a subquery?

1179

Do you know what is fill factor and pad index?

1004

What is a domain constraint give an example?

1051

What is scrollable cursor?

1044

What is temporary stored procedure?

952

How to convert binary strings into integers in ms sql server?

1034

When we should use @@error?

977

How to create nested stored procedure?

1026

What is the difference between primary key and unique constraints?

969

What is dbcc updateusage?

1212

If any stored procedure is encrypted, then can we see its definition in activity monitor?

994

Can we write ddl in trigger?

922

How to end a stored procedure properly in ms sql server?

1094

Mention the differences between local and global temporary tables.

1048