where conditions used only for comparing row values. having conditions u

what is difference between where clause and having clause?

Question Posted / rajesh dutta

Answer Posted / rajesh dutta

where conditions used only for comparing row values.

having conditions used to compares group values like
min,max,count etc.

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how the indexes are stored in the Oracle Database?

2212

What are the different types of synonyms?

1072

How can you use check constraints for self referential integrity?

911

Can we save images in a database and if yes, how?

997

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2247

What is difference between sid and service name in oracle?

903

What are a cluster and non-cluster index?

954

How to view the data files in the current database?

1037

How different is ms access and oracle?

986

What is system tablespace?

1039

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2431

interview questions with answer for cts

2529

what is normalisation?what are its uses?

2201

What are the different pseudo commands? Explain in general?

1019

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2242