Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35918 Views
- I also Faced
- E-Mail Answers
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
What is the difference between primary key and unique key and foreign key in oracle?
Where are the settings stored for each instance in oracle?
what is the difference between substr and instr function in oracle?
What is oracle latest version?
What is recovery manager in Oracle?
How to import one table back from a dump file?
How to invoke the original export import utilities?
How would you change old and new values in an insert, delete and update triggers?
How to use like conditions in oracle?
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.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain table?
what is the difference between functional dependecy and multilevel dependency?
What is a synonym? What are its various types?
How to create a table in a specific tablespace?
