Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Interview Questions
different kinds of Joins.
Posted By :
Posted Date :
September 03, 2011
JOIN - LEFT, RIGHT, CROSS, FULL
You can also find related Interview Question to
different kinds of Joins.
can you tell all types of joins?
1) equi joins
2) non equi joins
3) self joins
4) caresian joins
5) outer joins
Name the 2 kinds of procedures in VBScript?
Can We Rewrite Subqueries Into Simple Select Statements Or With Joins?
Subqueries can often be re-written to use a standard outer join, resulting in faster performance. As we may know, an outer join uses the plus sign (+) operator to tell the database to return all non-matching rows with NULL values. Hence we combine the outer join with a NULL test in the WHERE clause to reproduce the result set without using a sub-query.
What are cross joins?
? A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join.
? The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.
? Example: is when company wants to combine each product with a pricing table to analyze each product at each price.
Database: List different types of joins.
Inner join, Outer join, Self join
Database: List different types of outer joins.
Left outer join, right outer join, full outer join
joins in SQL SERVER
Joins Actualy performs Two or more table combined into a single result set..
Three are Four Types of joins in SQL SERVER.
1) inner join
2) Outer join(Left outer join,Right outer join)
3) Full join
4) Cross join
What kinds of fonts are supported with Silverlight?
Beyond standard and western fonts, Silverlight also supports East Asian characters, double-byte characters, and can work with any East Asian font or Middle Eastern font by using the glyphs element and a supporting TrueType font file that supports the requested glyph.
What are the various kinds of roles the users can have?
A user can be assigned one of the following roles
Reader - Has read-only access to the Web site.
Contributor - Can add content to existing document libraries and lists.
Web Designer - Can create lists and document libraries and customize pages in the Web site.
Administrator - Has full control of the Web site.
Which types of joins let you retrieve nonmatching data?
Full outer join and Left outer join
Quick Links For Interview Questions Categories:
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
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
Terms of Service
Tell A Friend