adspace


Define Joins?

Answer Posted / Jaswant Kumar

In SQL, a Join operation combines rows from two or more tables based on a related column between them. There are several types of joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of constraints?

1009


Can sql servers link to other servers like oracle?

934


List the ways in which dynamic sql can be executed?

1103


Why should you use or avoid select * statements?

1126


What is a view in sql?

1055


How can you append an identity column to a temporary table?

1083


How can I check that whether automatic statistic update is enabled or not?

1123


How raid can influence database performance?

1133


What is the difference between upgrade and migration in sql server?

1195


Can you index views?

960


What is sql or structured query language?

1239


What are the different types of subquery?

1241


How do I start sql server 2017?

1024


When should you use an instead of trigger?

1063


Why use identity in sql server?

1212