what is difference between where clause and having clause?
Answer Posted / shashikant
in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )
Is This Answer Correct ? | 44 Yes | 5 No |
Post New Answer View All Answers
Explain the difference between a procedure and a function? What do you understand by those terms?
How to insert a record into a table?
What happens if recursive calls get out of control?
Explain oracle data types with examples?
What to do if the startbd.bat failed to start the xe instance?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to shutdown your 10g xe server?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Can a parameter be passed to a cursor?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
List out the difference between commit, rollback, and savepoint?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is PL/SQL ?
How to delete a column in an existing table?
What are the four Oracle system processes that must always be up and running for the database to be useable?