.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

Difference between cross join and Full outer join

Posted By :Ashutosh Jha     Posted Date :December 30, 2013    Points :40   Category :Sql Server 
Cross Join :
No join conditions are specified.
Results in pairs of rows.
Results in Cartesian product of two tables.

Full Outer Join:
A combination of both left and right outer joins.
Results in every row from both of the tables , at least once.
Assigns NULL for unmatched fields.

You can also find related Interview Question to Difference between cross join and Full outer join  below: 

what is left outer join?

  

Matched records from the tables and unmatched records from left table. (More...)

What is the difference between JOIN and UNION

  
SQL JOIN allows us to "lookup" records on other table based on the given conditions between two tables. For example, if we have the department ID of each employee, then we can use this department ID of the employee table to join with the department ID of department table to lookup department names. (More...)

What is Thread.Join() in threading ?

  
There are two versions of Thread.Join :-
. Thread.join().
. Thread.join(Integer) this returns a Boolean value.
The Thread.Join method is useful for determining if a thread has completed before starting another task. The Join method waits a specified amount of time for a thread to end. If the thread ends before the time-out, Join returns true; otherwise it returns False. Once you call Join, the calling procedure stops and waits for the thread to signal that it is done.
Example you have "Thread1" and "Thread2" and while executing 'Thread1" you call "Thread2.Join()".So "Thread1" will wait until "Thread2" has completed its execution and the again invoke "Thread1".
Thread.Join(Integer) ensures that threads do not wait for a long time. If it exceeds a specific time which is provided in integer the waiting thread will start. (More...)

How do I invite users to join a Windows SharePoint Services Site? Is the site secure?

  
SharePoint-based Web sites can be password-protected to restrict access to registered users, who are invited to join via e-mail. In addition, the site administrator can restrict certain members' roles by assigning different permission levels to view post and edit. (More...)

What is a Join in SQL Server?

  
Join puts data from two or more tables into a single result set. (More...)

How do we join the values in an array?

  
Using the method Join() as follows.

var arr = new Array();
arr = ["one","two","three","four"];
alert(arr.join(",")); (More...)

Get data from 2 tables using join?

  
Select s.name,s.code,m.eng,m.math from Student S INNER Join Marks m on s.RollNo=m.RollNo; (More...)

Performance wise which one is the best? IN,EXISTS or INNER JOIN

  
It depends.

Generally speaking JOINs are much better than EXISTS & EXISTS is better than IN, performance wise.

If your result set is small then you can use IN or EXISTS.

But if result set contains a large set of records, then use JOINS.


(More...)

Difference between Server.Transfer and Cross Page Posting

  
In 'Server.Transfer', the URL doesn't change whereas in cross page posting, the form is submitted to a different page, thereby changing the url.
The Server.Transfer method is a server-based operation whereas cross-page postback is a client-based transfer. (More...)

What is Inner Join?

  
return rows when there is at least one match in both tables. (More...)

What is mean by JOIN and Types of JOIN?

  
Used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables.
Types of JOIN:
JOIN: Return rows when there is at least one match in both tables
LEFT JOIN: Return all rows from the left table, even if there are no matches in the right table
RIGHT JOIN: Return all rows from the right table, even if there are no matches in the left table
FULL JOIN: Return rows when there is a match in one of the tables
(More...)

What is Self Join?

  
To join within that table is called self join.

Example to check Duplicate Records:

select empid from employee where empid not in(select empid from employee group by empid having count(*)>1)

select empid a ,empname b from emp a, emp b
where a.empid=b.empid

Regards

sriram.R (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend