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
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is oracle and what are its different editions?
How to rename a tablespace in oracle?
What is the difference between truncate & delete command?
What is null value 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 create a temporary table in oracle?
How to invoke the original export import utilities?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is the difference between "as" and "is" in an oracle stored procedure?
What is a read only transaction in oracle?
How to Truncate Table in Oracle
What is key preserved table?
defination of bitmap index
What is materialized view in Oracle?