TDCX Digilab India Interview Questions and Answers

Join queries in SQL are used to combine rows from two or more tables based on a related column between them.

• Use JOIN keyword to combine rows from two or more tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Specify the columns to join on using ON clause

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

To find the sum of the first n prime numbers

• Iterate through numbers starting from 2 and check if each number is prime

• Keep track of the sum as you find each prime number

• Stop when you have found n prime numbers