what is difference between where clause and having clause?
Answer Posted / mrityunjay kumar dubey
A WHERE Clause is used to restrict a row and HAVING Clause is used to restrict a group.WHERE Clause can be used for specifying the search criteria in SELECT, DELETE, UPDATE statements.HAVING Clause is used when GROUP BY Clause is used.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is the difference between online and offline backups?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How many types of synonyms in Oracle?
How to revoke create session privilege from a user in oracle?
What happens to the current transaction if a ddl statement is executed?
What is using clause and give example?
What is an oracle recycle bin?
What is the difference between substr & instr functions?
Explain rename?
What is an oracle user role?
How to see free space of each tablespace?
what is port in oracle? how is it related to database application.
What is memory advisor in Oracle?
What is translate in oracle?