what is difference between where clause and having clause?
- 13 Answers
- 32911 Views
- I also Faced
- E-Mail Answers
Answer Posted / arkchowdary
Where Clause------------------ It is used to Filter Rows
(i.e Restrict Rows and It appiles to the Individual Rows).
Having Clause----------------- It appies on Groups (i.e
Aggregate Functions).
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
Differentiate between function and procedure in oracle.
How to retrieve the count of updated rows?
What is a dynamic performance view in oracle?
How to assign a table row to a record variable?
What is SQL Tuning Advisor in Oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is tns service name?
What types of joins are used in writing subqueries?
Explain oracle left join with an example?
Can a formula column be obtained through a select statement ?
What is the use of oracle?
what is the scenario where you take the database to NoArchivelog mode?
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.
How to convert numbers to characters in oracle?
what is the difference between data migration and production migration.
