HAVING clause can only compare a built in function but WHERE clause can co

what is the difference between where clause and having clause

Question Posted / selvam a

Answer Posted / selvam a

HAVING clause can only compare a built in function but WHERE
clause can compare column name.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the contents of dclgen?

1107

What is nvl in db2?

1089

What are the bind parameters ibm db2?

1046

What is dbrm library?

1049

What is db2 look?

1020

What is difference between isnull and coalesce?

1052

What is dbrm? What it contains?

1163

What does a deadlock mean in DB2?

1160

What is the maximum length of sqlca?

1523

What is the connection string to connect to the DB2 Database ?

1125

Explain about open switch business continuity software?

1127

What are db2 objects?

1045

Can we insert update delete in view?

967

What is bind in db2?

1038

What is a cursor in programming?

1066