Question
A table T has exactly 10 rows. Its column X contains 3 NULL values among its 10 entries, and of the remaining 7 non-null values, exactly two are duplicates of each other (all other values are unique). What will SELECT COUNT(*), COUNT(
- X , COUNT(DISTINCT
- X FROM T return, respectively?
More SQL Questions
- Which SQL feature allows hierarchical queries (e.g., org chart traversal)?
- 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?
- ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
- Which SQL statement combines the results of two queries and removes duplicates?
- Which SQL keyword is used to eliminate duplicate rows in a query result?
- Which SQL aggregate function returns the total number of rows matching a specified condition?
- Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
- Which SQL keyword prevents duplicate rows in result?
- A transaction in DBMS is said to be atomic if:
- Which SQL clause is used to filter results after a GROUP BY operation?
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)