Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35939 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 is the maximum limit on the number of columns in a table?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is data type in oracle?
Explain oracle data types with examples?
How can we find out the current date and time in oracle?
Explain what are the characteristics of data files?
what are actual and formal parameters?
How to sort output in descending order in oracle?
What privilege is needed for a user to connect to oracle server?
interview questions with answer for cts
How to convert character types to numeric types?
How to define an anonymous block?
What is sharded cluster?
How to insert multiple rows with one insert statement in oracle?
What is oracle open database communication (odbc)?
