Question
Table Orders(OrderID, CustomerI
- D has 10 rows with CustomerID values: C1, C1, C2, C3, C1, C2, C4, C2, C3, C1. How many groups (customers) will be returned by the following query? SELECT CustomerID, COUNT(*) FROM Orders GROUP BY CustomerID HAVING COUNT(*) >= 2;
More SQL Questions
- 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...
- What is the output of this SQL snippet if the price column contains NULL values? SELECT SUM(price) FROM products;
- Materialized views differ from normal views because:
- A transaction in DBMS is said to be atomic if:
- 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...
- 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...
- A table has a B-tree index on the 'Name' column. Which of the following queries is LEAST likely to benefit from this index?
- What is the result of SELECT COUNT(NULL) on any table?
- Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?
- 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)