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 of the following is a mandatory component of a PL/SQL function's definition?
- 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 clause is used to filter records based on aggregate functions?
- Which SQL keyword prevents duplicate rows in result?
- Transaction T1 runs 'SELECT COUNT(*) FROM Orders WHERE Amount > 1000' twice within the same transaction. Between the two reads, T2 inserts a new qualifying...
- In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
- Which operator is used to combine results of two SELECT queries and remove duplicates?
- A materialized view differs from a normal view because it:
- 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 SQL keyword is used to eliminate duplicate rows in a query result?
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)