1) Inner join or Equi join
2) Self Join (it can be considered as the part of Inner join)
3) Outer Join
4) Cross join
Read more about Sql Joins
2.What are the Inner joins?
Inner joins:- This type of join is also known as the Equi join. This join returns all the rows from both tables where there is a match. This type of join can be used in the situation where we need to select only those rows which have values common in the columns which are specified in the ON clause.
Read more about Inner Joins
3. What are the Self Joins?
Self Joins:-Sometime we need to join a table to itself. This type of join is called Self join. In this Join, we need to open two copies of a same table in the memory. Since the table name is the same for both instances, we use the table aliases to make identical copies of the same table to be open in different memory locations.
Read more about Self Joins
4. What are the Outer Joins?
Outer Joins:-This type of join is needed when we need to select all the rows from the table on the left (or right or both) regardless of whether the other table has common values or not and it usually enter null values for the data which is missing.
- Left Outer Join
- Right Outer Join
- Full Outer Join
Read more about Outer Joins
5.What are the Cross Joins?
Cross Joins:-This join combines all the rows from the left table with every row from the right table. This type of join is needed when we need to select all the possible combinations of rows and columns from both the tables. This type of join is generally not preferred as it takes lot of time and gives a huge result that is not often useful.
Read more about Cross Joins
6. What are the Indexes in Sql server?
2) Non Clustered Index
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
… [Trackback]
[…] Read More on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] There you can find 77389 more Information on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Read More Information here on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] There you can find 87809 more Information on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Here you will find 75785 more Info to that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Read More on to that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] There you can find 20201 additional Info on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Here you can find 2144 more Info on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Read More Info here on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Read More on on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Read More here to that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More here on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2010/01/interview-questions-on-sql-server-par.html […]