Having clause ia used only with group by, and where used with any input typ

what is difference between having and where clause ?

Question Posted / anil sharma

Answer Posted / anil sharma

Having clause ia used only with group by, and where used with any input type

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is function of ROLLUP ?

1093

What do you understand by coalesce in sql server?

1080

What is the default Port No on which SQL Server listens?

1132

What happens if null values are involved in comparison operations?

989

What is a partitioned view?

1007

Explain what is the difference between union and union all?

1018

Can you explain what are commit and rollback in sql?

946

What are constraints?

1019

Explain sql server authentication modes?

1138

Explain what is lock escalation and what is its purpose?

938

List the ways in which dynamic sql can be executed?

1021

What is the main difference between ‘between’ and ‘in’ condition operators?

1202

Explain what is the use of custom fields in report?

932

What is temporary table in sql server? Why we use temp table?

957

What are the different types of upgrades that can be performed in sql server?

1180