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

State some uses of redo log files?

575


How to load excel data sheet to oracle database

598


What is oracle and what are its different editions?

588


What is an oracle data file?

627


In oracle there is column command, how will you explain that?

559






How to end the current transaction in oracle?

574


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1512


How to open a cursor variable?

622


What is a subquery?

622


Can you create a synonym without having a table?

563


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1456


Explain an index segment?

657


What is Reduced List of Values?

1718


How to turn on or off recycle bin for the instance?

623


How to convert raw data type into text in oracle? Explain

615