Question
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
More SQL Questions
- Orders(OrderID, CustomerID, Amount) has multiple orders per customer. Which query returns customers whose total order amount exceeds 100000?
- 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 statement combines the results of two queries and removes duplicates?
- A column named Salary in a table contains the values 50000, NULL, 60000, and 70000. What value will the SQL expression AVG(Salary) return for this column?
- Which SQL feature allows hierarchical queries (e.g., org chart traversal)?
- SQL Injection can be prevented by all EXCEPT:
- Deadlock in DBMS can be prevented using:
- Which type of SQL subquery references one or more columns from its outer (enclosing) query, and as a result must be logically re-evaluated once for every r...
- Customers(cust_id,name): (1,'A'),(2,'B'),(3,'C'). Orders(order_id,cust_id,amount): (1,1,200),(2,2,150),(3,1,300),(4,3,100). What does the following query r...
- 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...
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)