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 is sharded cluster?

516


How to list all indexes in your schema?

574


How many types of synonyms in Oracle?

589


Explain an integrity constrains?

694


How to convert characters to dates in oracle?

559






How do I limit the number of oracle database connections generated by weblogic server?

543


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1614


Is there a function to split a string in plsql?

564


What is data block in Oracle?

615


State the various uses of dbcc command?

544


Explain mutating triggers.

567


What are triggers in oracle?

553


Is oracle the best database?

514


How data locks are respected in oracle?

568


Why do we need integrity constraints in a database?

582