what is difference between where clause and having clause?
Answer Posted / narender sharma
Where clause is used to restrict rows but having clause is
used to restrict groups
Is This Answer Correct ? | 28 Yes | 3 No |
Post New Answer View All Answers
What are ddl statements in oracle?
How to convert csv to table in oracle?
What are the tools for Oracle ?
Explain oracle insert into command?
what's query optimization and without use of IN AND Exist can we get another way data from query
Can you tell me how to add new column in existing views?how?How is possible?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What privilege is needed for a user to delete rows from tables in another schema?
What do you know about normalization? Explain in detail?
What are the ansi data types supported in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is open database communication (odbc) in oracle?
What is data type in oracle?
Why we use bulk collect in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?