Question
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 side?
More SQL Questions
- Which SQL keyword prevents duplicate rows in result?
- Consider two tables: Employees(EmpID, Name, DeptID) with 8 rows, and Departments(DeptID, DeptName) with 3 rows. Every employee has exactly one valid DeptID...
- A view is defined as: CREATE VIEW V AS SELECT dept_id, AVG(salary) AS avg_sal FROM Employees GROUP BY dept_id; Can this view be used directly in an UPDATE ...
- Table T(A,B) contains: (1,NULL), (NULL,2), (3,4), (NULL,NULL). How many rows are returned by the following query? SELECT * FROM T WHERE A=3 OR B=4;
- 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 SQL clause is used for filtering rows?
- Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
- 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 feature allows hierarchical queries (e.g., org chart traversal)?
- 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...
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)