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
How to create a server parameter file?
Explain drop constraint oracle?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is key preserved table?
How to build data dictionary view an new database?
What is oracle host variable?
Can a formula column referred to columns in higher group ?
what is normalisation?what are its uses?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is the parameter mode that can be passed to a procedure?
Explain alias?
Compare and contrast between sql and sql server and explain its various functions?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is varray?
Can you tell me how to add new column in existing views?how?How is possible?