in 'where' clause every records filtered based on where in '

what is difference between where clause and having clause?

Question Posted / shashikant

Answer Posted / shashikant

in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )

Is This Answer Correct ?

44 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are joins, explain all types of joins?

2266

What is connection pool in oracle?

970

what is the dual table in oracle?

970

How do I escape a reserved word in oracle?

1183

Give the different types of rollback segments.

1015

Explain the use of ignore option in imp command.

1016

How do we get field detail of a table?

1056

How to create a new tablespace in oracle?

966

What is transaction control statement and how many types of transaction control statement in Oracle?

1130

How to assign values to variables?

1077

What is rowid and rownum in oracle?

992

How to retrieve data from an cursor to a record?

1073

What are the major difference between truncate and delete?

1032

Please explain oracle left join with an example?

1018

Explain the truncate in oracle?

944