TYPES OF JOIN USED IN MYSQL

-

 

Definition: INNER JOIN

Returns rows where there is a match in both tables based on the common id.

SELECT * FROM employee INNER JOIN department ON employee.id = department.id;


Definition: LEFT JOIN

Returns all rows from the "employee" table and matched rows from the "department" table. If there is no match, NULL values are returned for "department" columns.

SELECT * FROM employee LEFT JOIN department ON employee.id = department.id;


Definition: RIGHT JOIN

Returns all rows from the "department" table and matched rows from the "employee" table. If there is no match, NULL values are returned for "employee" columns.

SELECT * FROM employee RIGHT JOIN department ON employee.id = department.id;


Definition: FULL JOIN

Returns all rows when there is a match in either "employee" or "department" table. If there is no match, NULL values are returned for columns from the table without a match.

SELECT * FROM employee FULL JOIN department ON employee.id = department.id;


Definition: CROSS JOIN

Returns all the records of "employee" and "department" tables, i.e., all possible combinations.

SELECT * FROM employee CROSS JOIN department;

Previous
Next

Comments

Post a Comment

Popular posts from this blog

Python program to sum up the Salary when the Name and Age matches with subsequent rows.

-
I have a .txt file as per below content with 4 fields as Name, Age, Salary and Date of Salary received Vijay,35,6000,29-12-2023 Manoj,32,12000,29-7-2023 Vinoth,31,11000,29-12-2023 Vijay,32,10000,29-10-2023 Vijay,32,7000,29-12-2023 Manoj,30,10000,29-11-2023 Vinoth,32,10000,29-10-2023 Vijay,32,10000,29-4-2023 Mano,32,1000,29-12-2023 Vijay,32,3000,29-8-2023 I wish to write a python program to sum up the Salary when the Name and Age matches with subsequent rows. Will you able to do the code ? Certainly! You can achieve this by reading the contents of the file, parsing each line to extract the relevant information (Name, Age, Salary), and then using a dictionary to store the sum of salaries for each unique combination of Name and Age. Here's a Python program that accomplishes this: def read_file(file_path): data = [] with open(file_path, 'r') as file: for line in file: line = line.strip() if line: name, age, salary, _ = l...
Read more

Automation using selenium and python/java interview question to order a product in e commerce website.

-
Image
 1. Open the browser  2.  Go to the address bar and type  "https://www.flipkart.com/"          3. Select the search bar and enter "poco c65 mobiles" 4. Select the desired mobile by clicking on it. 5. Click on add to cart button. 6. Click  the place order button. 7.Enter mobile number and click continue. 8.Enter the OTP and click sign up. 9. After entering multiple wrong OTP the  system throws an error All the above steps should be automated.
Read more