What are joins..how many types of joins are there?
Answer Posted / akn
In SQL Server,Join actually puts data from two or more
tables into a sinle result set.
there are 3 types of joins
1.Inner join
2.Outer join
3.Cross join
| Is This Answer Correct ? | 73 Yes | 40 No |
Post New Answer View All Answers
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is analyze command used for?
Can objects of the same schema reside in different tablespace?
What are the different types of modules in oracle forms?
Explain what are the uses of rollback segment?
Explain the use of analyse option in exp command.
what is the scenario where you take the database to NoArchivelog mode?
What is a tns file?
What is data block in Oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is the difference between online and offline backups?
what are the default admin accounts in Oracle 10g ?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Why cursor variables are easier to use than cursors?
Explain what are clusters?