HAVING clause is used only with GROUP functions whereas WHERE clause we c

what is difference between where clause and having clause?

Question Posted / pawan

Answer Posted / pawan

HAVING clause is used only with GROUP functions whereas
WHERE clause we can use with both.

Is This Answer Correct ?

8 Yes

15 No

Please Help Members By Posting Answers For Below Questions

Explain the use of rows option in imp command.

1139

Where is the export dump file located?

1224

How to update a table row with a record?

1067

How to create a stored function in oracle?

1158

How many types of segments in Oracle?

1116

State all possible different index configurations a table can possibly have?

1104

Explain an index?

1182

What is a user role in oracle?

1186

What are the differences between date and timestamp in oracle?

1097

What is a database table in oracle?

1071

Please explain oracle data types with examples?

1132

How to create a stored procedure in oracle?

1153

Explain the use of ignore option in imp command.

1087

How to declare a local variable?

1175

Point out the difference between user tables and data dictionary?

1037