Can you explain the types of Joins that we can have with Sql
Server?

Answer Posted / guest

There are three types of joins: Inner Join, Outer Join,
Cross Join

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is buffer cash and log cache in sql server?

799


Which tcp/ip port does sql server run on? How can it be changed?

762


What are subqueries in sql server? Explain its properties.

723


What gets stored inside msdb database?

946


Explain table valued parameters in sql server? Why tvp used?

730






How to sort query output in descending order in ms sql server?

745


What is rank function?

788


How to move database physical files in ms sql server?

691


Explain boyce and codd normal form(bcnf)?

699


What are the components of dbms?

717


What is dimension table? : sql server analysis services, ssas

747


What is the difference between executequery () and executeupdate ()?

711


What is the contrast amongst drop and truncate?

755


What is outer join in sql server joins?

748


Why variables called the most powerful component of ssis?

802