Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36868 Views
- I also Faced
- E-Mail Answers
Answer Posted / sonali
1.where clause is apply on individual row ofthe table and
having is apply on group of rows in the output of select
statement.
2.having clause is used with group by clause
3.having clause is used as a final filter on the aggregate
column values in the resultset of select statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What exactly do quotation marks around the table name do?
What are the limitations oracle database 10g xe?
What is the quickest way to fetch the data from a table?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What are the logical operations?
How do you tell what your machine name is and what is its IP address?
What is an oracle data file?
What is the oracle implicit cursor?
What is a cursor variable?
What is backup in Oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
What is a system tablespace and when it is created?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the components of logical database structure in oracle database?
What happens if the imported table already exists?
