Where clause | Having clause |
Both where and having clause can be used to filter the data. | |
Where as in where clause it is not mandatory. | But having clause we need to use it with the group by. |
Where clause applies to the individual rows. | Where as having clause is used to test some condition on the group rather than on individual rows. |
Where clause is used to restrict rows. | But having clause is used to restrict groups. |
Restrict normal query by where | Restrict group by function by having |
In where clause every record is filtered based on where. | In having clause it is with aggregate records (group by functions). |
Saturday, 18 June 2011
Differences between where clause and having clause ?
Labels:
Oracle FAQs
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment