Question
A table T has a column score with values 10, 20, NULL, 20, 30. What does SELECT COUNT(*), COUNT(score), COUNT(DISTINCT score) FROM T return?
More SQL Questions
- What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
- Table Employee(EmpID, ManagerID) has 6 rows: (1,NULL), (2,1), (3,1), (4,2), (5,2), (6,3). How many rows will the following self-join return? SELECT E.EmpI...
- Which clause is used to sort query results in SQL?
- Which SQL keyword prevents duplicate rows in result?
- Materialized views differ from normal views because:
- SQL Injection can be prevented by all EXCEPT:
- Which query returns departments whose average salary is greater than 60000?
- A table emp has salaries 50, 70, 70, 90, 90. What does the following query return? SELECT MAX(salary) FROM emp WHERE salary < (SELECT MAX(salary) FROM...
- In SQL, what is the primary purpose of the GROUP BY clause?
- 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 ...
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)