Question
What does the following query return? SELECT name FROM emp WHERE salary > ALL (SELECT salary FROM emp WHERE dept = 'HR');
More SQL Questions
- 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 SQL aggregate function returns the total number of rows matching a specified condition?
- Table A has the values {1, 2, 2, 3} in column x and table B has the values {2, 2, 3, 4} in column y. How many rows does SELECT * FROM A FULL OUTER JOIN B O...
- For the table Employees(EmpID, Name, Dept, Salary), which SQL query correctly retrieves all employees who earn more than the average salary of their own de...
- In normalization, which normal form removes transitive dependencies?
- Table Employee(EmpID, ManagerID) has 6 rows: (1,NULL), (2,1), (3,1), (4,2), (5,2), (6,3). How many rows will the following self-join return? SELECT E.EmpI...
- 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 w...
- 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 constraint ensures that a column’s values are unique across the table?
- A table T has a column Marks with the values 10, 20, NULL, 20, 30. What is the result of: SELECT COUNT(*) + COUNT(DISTINCT Marks) + AVG(Marks) FROM T;
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)