How do you get all records from 2 tables. Which join do you use?
Answer Posted / rao
Using FULLOUTER JOIN
| Is This Answer Correct ? | 25 Yes | 2 No |
Post New Answer View All Answers
What is procedure function?
what are the performance and scalability characteristics of mysql? : Sql dba
Can we create foreign key without primary key?
How to pipe multiline string to isql?
Can we join same table in sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
Can you do multiple joins in sql?
How do you delete a table?
Which are the different case manipulation functions in sql?
How do you declare a constant?
Enlist the characteristics of pl/sql?
what are date and time intervals? : Sql dba
what are the advantages of mysql in comparison to oracle? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
i have some prob lem to tell me about my self in interview first round ...