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
- Which SQL keyword removes duplicate rows automatically from results?
- Which SQL function returns the largest value in a column?
- A materialized view differs from a normal view because it:
- Which SQL operator is used to search for a pattern in a column?
- A table T has a column score with values 10, 20, NULL, 20, 30. What does SELECT COUNT(*), COUNT(score), COUNT(DISTINCT score) FROM T return?
- What is the main function of a "foreign key" in a relational database table?
- Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
- Which operator is used to combine results of two SELECT queries and remove duplicates?
- 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...
- ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
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)