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
- Given Employee(EmpID, Name, Salary, ManagerID), which query correctly lists employees who earn more than their own manager?
- Which SQL keyword removes duplicate rows automatically from results?
- What does the following query return? SELECT name FROM emp WHERE salary > ALL (SELECT salary FROM emp WHERE dept = 'HR');
- Table X has a column v with values (1, 2, 2, 3) and table Y has a column v with values (2, 2, 3, 4). How many rows does X FULL OUTER JOIN Y ON X.v = Y.v re...
- Which SQL function is used to calculate the average of a numeric column?
- Which of the following SQL constructs avoids returning duplicate rows?
- Which SQL keyword is used to remove duplicate records from a query result?
- A materialized view differs from a normal view because it:
- 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;
- Which SQL command is used to modify existing records in a table?
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)