Question
Which of the following SQL operations is used to combine
data from two or more tables based on a related column?Solution
The JOIN operation in SQL is used to combine rows from two or more tables based on a related column between them. This is essential in relational database management systems (RDBMS) when you need to combine data stored in separate tables based on a common field. There are various types of joins, such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN, which allow you to control how the data from the related tables is combined. JOIN is fundamental in SQL queries to link data across tables and perform meaningful analysis. The other options are incorrect because: • Option 2 (UNION) combines the results of two SELECT queries, but it does not join tables based on a common column. It simply appends rows from the result sets. • Option 3 (INTERSECT) returns only the rows that are present in both SELECT query results, which is different from joining tables. • Option 4 (SELECT) is a basic SQL command used to retrieve data from a database but does not combine tables. • Option 5 (GROUP BY) is used to group rows based on a specified column, typically for aggregation, and does not combine tables.
When is the Z-Morh tunnel, connecting Kashmir and Ladakh, scheduled to be inaugurated?
How much investment has been approved for the National Critical Mineral Mission (NCMM)?
What is the name of the hydropower project jointly undertaken by Assam and Meghalaya?Â
What is the name of the second Anti-Submarine Warfare Shallow Water Craft (ASW-SWC) received by the Indian Navy in 2025?Â
Which city is hosting the 18th International Olympiad on Astronomy and Astrophysics (IOAA) in 2025?Â
What is the primary goal of Tata Power’s $4.25 billion MoU with the Asian Development Bank (ADB)?
Why did India's rank drop from 80th in 2024 to 85th in the Henley Passport Index 2025?
Who was appointed to the Executive Committee of the US-India Strategic Partnership Forum (USISPF) in 2025?
India's budget carrier IndiGo has onboarded Juspay as its official payment partner to handle payments for direct bookings on the airline's app and websi...
Which initiative is DPIIT launching under the Startup India program to boost India's startup ecosystem?