Question
Consider two tables: Employees(EmpID, Name, DeptI
- D with 8 rows, and Departments(DeptID, DeptName) with 3 rows. Every employee has exactly one valid DeptID, and every department has at least one employee. How many rows will the following query return? SELECT E.Name, D.DeptName FROM Employees E INNER JOIN Departments D ON E.DeptID = D.DeptID;
More SQL Questions
- Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
- Which type of SQL subquery references one or more columns from its outer (enclosing) query, and as a result must be logically re-evaluated once for every r...
- Which SQL aggregate function returns the number of rows in a column that contain a non-NULL value, ignoring NULL entries in that 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 type of SQL join returns only those rows that have matching values present in both of the joined tables, excluding any unmatched rows from either sid...
- In normalization, which normal form removes transitive dependencies?
- Which of the following can be used to avoid duplicate entries in a column?
- Which SQL function is used to calculate the average of a numeric column?
- Which SQL constraint ensures that a column’s values are unique across the table?
- Which SQL keyword is used to remove duplicate records from a query result?
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)