Question
Table Students(StudentID, Marks) contains the marks: 45, 67, 89, 72, 90, 55, 78. What will the following query return? SELECT COUNT(*) FROM Students WHERE Marks > (SELECT AVG(Marks) FROM Students);
More SQL Questions
- Which SQL constraint ensures that a column’s values are unique across the table?
- Which SQL command permanently removes both the stored data and the entire structural definition (columns, constraints, indexes) of a table from the databas...
- In SQL, what is the difference between 'WHERE' and 'HAVING' clauses?
- Which SQL clause is used to filter groups after aggregation (i.e., having aggregated value conditions)?
- Orders(OrderID, CustomerID, Amount) has multiple orders per customer. Which query returns customers whose total order amount exceeds 100000?
- A view is defined as: CREATE VIEW V AS SELECT dept_id, AVG(salary) AS avg_sal FROM Employees GROUP BY dept_id; Can this view be used directly in an UPDATE ...
- Which clause is used to sort query results in SQL?
- Materialized views differ from normal views because:
- Which SQL operator is used to search for a pattern in a column?
- What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
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)