Question
Which type of SQL join returns all rows from the left table along with matching rows from the right table, filling in NULLs for the right table's columns when no match exists?
More SQL Questions
- What is the main function of a "foreign key" in a relational database table?
- Which SQL keyword prevents duplicate rows in result?
- Which SQL operator is used to search for a pattern in a column?
- A table emp has salaries 50, 70, 70, 90, 90. What does the following query return? SELECT MAX(salary) FROM emp WHERE salary < (SELECT MAX(salary) FROM...
- Which SQL clause is used for filtering rows?
- Which SQL function is used to calculate the average of a numeric column?
- Table A has 5 rows and Table B has 4 rows. Exactly 3 rows in A each match exactly one row in B under a given join condition (the remaining 2 rows in A have...
- Which SQL keyword is used to eliminate duplicate rows in a query result?
- Which clause is used to sort query results in SQL?
- In SQL, what is the primary purpose of the GROUP BY clause?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)