Question
Table T has five rows and X values (10,20,NULL,20,NUL
- L . What does SELECT COUNT(
- X FROM T return?
More SQL Questions
- Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
- 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...
- Which SQL aggregate function returns the number of rows in a column that contain a non-NULL value, ignoring NULL entries in that column?
- 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...
- Which type of SQL join returns only those rows that have matching values present in both of the joined tables, excluding any unmatched rows from either sid...
- In normalization, which normal form removes transitive dependencies?
- Which of the following can be used to avoid duplicate entries in a column?
- Which SQL function is used to calculate the average of a numeric column?
- Which SQL constraint ensures that a column’s values are unique across the table?
- Which SQL keyword is used to remove duplicate records from 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)