what is difference between where clause and having clause?

Answer Posted / yogesh babu

where is also similar to that of where clause used ina
query ... But this search filter is used while using a
groupby clause

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between date and timestamp in oracle?

556


What is the sql query to concatenate column values from multiple rows in oracle?

567


How to increment dates by 1 in oracle?

564


What are a query and state the different types of queries and their uses?

513


What is Reduced List of Values?

1708






From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

596


What is dynamic proxy?

554


What is bulk load in oracle?

597


What is not equal to in oracle?

531


What is the usage of save points in oracle database?

533


What is raw datatype in oracle?

586


List out the difference between commit, rollback, and savepoint?

622


Explain what are synonyms used for?

612


Explain a segment?

621


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1626