Question
Employees and salaries: Alice=9000, Bob=7000, Carol=9500, Dave=7000. What rank does Dave receive from the following query? SELECT name, salary, RANK() OVER (ORDER BY salary DES
- C AS rnk FROM Employees;
More SQL Questions
- In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
- In normalization, which normal form removes transitive dependencies?
- 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...
- Table Orders(OrderID, CustomerID) has 10 rows with CustomerID values: C1, C1, C2, C3, C1, C2, C4, C2, C3, C1. How many groups (customers) will be returned ...
- Materialized views differ from normal views because:
- Which SQL function returns the largest value in a column?
- Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
- Table B contains a NULL value in its 'id' column. Consider: SELECT * FROM A WHERE A.id NOT IN (SELECT id FROM B). What happens?
- Which command removes all rows but keeps table structure?
- What does the following query return? SELECT name FROM emp WHERE salary > ALL (SELECT salary FROM emp WHERE dept = 'HR');
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)