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
What is coalesce function?
What is concurrency in oracle?
What is ordinary table in oracle?
Explain oracle left join with an example?
How would you change old and new values in an insert, delete and update triggers?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to define a variable of a specific record type?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to define an anonymous procedure without variables?
Can we create trigger on materialized view in oracle?
what is Single Byte Overhead...?
What is oracle server autotrace in oracle?
How to define an anonymous block?
How to assign a table row to a record variable?