Question
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 no matching row in
- B . What are the row counts returned by a CROSS JOIN of A and B, and a LEFT OUTER JOIN (A LEFT JOIN
- B on that condition, respectively?
More SQL Questions
- In SQL, what is the difference between 'WHERE' and 'HAVING' clauses?
- Which SQL aggregate function returns the number of rows in a column that contain a non-NULL value, ignoring NULL entries in that column?
- Which SQL clause is used for filtering rows?
- Consider two tables: Employees(EmpID, Name, DeptID) with 8 rows, and Departments(DeptID, DeptName) with 3 rows. Every employee has exactly one valid DeptID...
- Employees and salaries: Alice=9000, Bob=7000, Carol=9500, Dave=7000. What rank does Dave receive from the following query? SELECT name, salary, RANK() OVE...
- Which command removes all rows but keeps table structure?
- To rename a column in a SELECT query result, you use:
- Transaction T1 runs 'SELECT COUNT(*) FROM Orders WHERE Amount > 1000' twice within the same transaction. Between the two reads, T2 inserts a new qualifying...
- Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
- Which SQL function is used to calculate the average of a numeric column?
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)