Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35940 Views
- I also Faced
- E-Mail Answers
Answer Posted / pawan
HAVING clause is used only with GROUP functions whereas
WHERE clause we can use with both.
| Is This Answer Correct ? | 8 Yes | 15 No |
Post New Answer View All Answers
What are the ways tablespaces can be managed and how do they differ?
State the difference between a primary key and foreign key?
What is a data lock in oracle?
How will you write a query to get a 5th rank student from a table student_report?
How to join two tables in a single query using oracle?
How to change system global area (sga) in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to convert character types to numeric types?
How to select an oracle system id (sid)?
What is Virtual Private Database in Oracle?
How to rename a tablespace in oracle?
What types of joins are used in writing subqueries?
What is the difference between translate and replace?
What is oracle open database communication (odbc)?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
