Question
A table has salaries 90000, 90000, 85000, 80000 (sorted descending). Using RANK() OVER (ORDER BY Salary DES
- C , what ranks are assigned, and how does this differ from DENSE_RANK()?
More SQL Questions
- Which SQL keyword prevents duplicate rows in result?
- Given Employee(EmpID, Name, Salary, ManagerID), which query correctly lists employees who earn more than their own manager?
- Which command removes all rows but keeps table structure?
- A materialized view differs from a normal view because it:
- A table T has exactly 10 rows. Its column X contains 3 NULL values among its 10 entries, and of the remaining 7 non-null values, exactly two are duplicates...
- To rename a column in a SELECT query result, you use:
- Which operator is used for pattern matching in SQL?
- 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...
- In SQL, what is the difference between 'WHERE' and 'HAVING' clauses?
- 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;
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)