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

How to fetch the row which has the max value for a column?

1046

Explain the use of parfile option in exp command.

1140

Explain about functional dependency and its relation with table design?

1061

What is the sid in oracle?

1032

query optmization techniques and quwry analyser+projects+ppts

2468

Can we connect to ORACLE db using Windows Authentication?

1308

Explain the use of show option in imp command.

1149

What are the differences between char and varchar2 in oracle?

1249

What is an oracle user account?

1043

Explain an index segment?

1160

What is enter substitution variable in oracle?

1097

What is a static data dictionary in oracle?

1192

How oracle handles dead locks?

1131

What is oracle rowcount?

1147

What is hash cluster in oracle?

1250