Having clause is used before aggregation and where clause is used before a

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

Question Posted / santosh pashupatimath

Answer Posted / santosh pashupatimath

Having clause is used before aggregation and where clause is
used before aggregation

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

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

1175

How to execute stored procedure in select statement sql server?

1061

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

987

What are locks in sql?

978

How to list all objects in a given schema?

1057

What do you mean by 'normalization'?

1060

how many no of arguments can be passed in procedures and functions

5561

What are the basic functions for master, msdb, model, tempdb databases?

1041

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

How to call a function from a stored procedure in SQL Server ?

1029

What is an active database?

1011

What is the difference between rank and dense_rank?

1084

What are the authentication modes in sql server? How can it be changed?

1127

What is the difference between char and varchar2 datatype in sql?

1066

What are the differences between local and global temporary tables?

1082