what is difference between where clause and having clause?
Answer Posted / rajesh dutta
where conditions used only for comparing row values.
having conditions used to compares group values like
min,max,count etc.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to use like conditions in oracle?
How do I spool to a csv formatted file using sqlplus?
What is the difference between post-database commit and post-form commit?
How to manage transaction isolation level?
How to view the data files in the current database?
Explain enable novalidate constraint.
Explain about your project and its relation to the current job position you are applying to?
What is the quickest way to export a table to a flat file?
What privilege is needed for a user to delete rows from tables in another schema?
Give syntax for SQL and ORACLE joins.
What is a trigger and what are its types in oracle?
How remove data files before opening a database?
Explain view?
What is a trace file and how is it created in oracle?