Please let me know if UNION ALL and Natural Join does the
same operation and are same...
Answer Posted / swathi
no,both are not same.we are using the union all condition ,we will get the duplicate columns and which field we are selecting it get the total information of that ,But by using Natural join we can't get the all information,some columns are removed.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How does sql*loader handles newline characters in a record? : aql loader
what are different types of collation sensitivity? : Sql dba
Can a commit statement be executed as part of a trigger?
What is difference between inner join and self join?
What is the basic structure of an sql?
Explain what is a view?
Will truncate release space?
How to disable a trigger name update_salary?
How do you create an update query?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Is sql scripting language?
Which is better stored procedure or query?
How to revise and re-run the last sql command?
What are the types of index in sql?
What is microsoft t sql?