explain different types of jions with examples briefly?
Answer Posted / vijay
The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database
Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join
3.Cross Join
4.Self Join
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is difference between delete & truncate commands?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is the Control Flow in SSIS
What is recompile sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
How can we delete a table in sql server?
Disadvantages of the indexes?
What are the new scripting capabilities of ssms? : sql server management studio
What is identity?
Explain how you can configure a running aggregate in SSRS?
Explain activity monitors
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is a ddl statement?
What are Row versions of DataRow?
Name few of the dcl commands in sql?