query:WHERE DEPARTMENT > 333 query:HAVING AVG(SALARY)

what is difference between where clause and having clause?

Question Posted / suga priya

Answer Posted / suga priya

query:WHERE DEPARTMENT > 333

query:HAVING AVG(SALARY) > 50000.

Is This Answer Correct ?

18 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to export data with a field delimiter?

969

What privilege is needed for a user to query tables in another schema?

919

What is a system tablespace?

1004

How can I get column names from a table in oracle?

983

What do you understand by a database object? Can you list a few of them?

970

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

947

What are the differences between char and nchar in oracle?

1021

How to do paging with oracle?

948

How to load data from external tables to regular tables?

986

How does the on-delete-cascade statement work?

1059

How will you differentiate between varchar & varchar2?

991

What are the differences between primary key and unique key?

947

What are the various types of snapshots ?

970

What is dynamic proxy?

959

What is meant by an index?

1058