what is difference between where clause and having clause?
Answer Posted / manvendra
RISTRICT GROUP BY FUNCTION BY HAVING.
RESTRICT NORMAL QUERY BY WHERE.
YOU CAN PUT WHERE AND HAVING IN A QUERY.
| Is This Answer Correct ? | 14 Yes | 21 No |
Post New Answer View All Answers
How to specify default values in insert statement using oracle?
What is the difference between alert log file and tarce file ?
What is transport network substrate (tns) in oracle?
How to assign a table row to a record variable?
What is the relation of a user account and a schema in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to view existing locks on the database?
How do we get field details of a table?
What is a oracle database?
How to use "in" parameter properly?
What are the advantages of oracle 12c?
Can we use bind variables in oracle stored procedure?
How to convert characters to times in oracle?
How to change system global area (sga) in oracle?
What is the usage of analyze command in oracle?