Which aggregate function in SQL displays the number of values in the specified column ignoring the NULL values?
Show Hint
COUNT(*) to count all rows including NULLs,and
COUNT(column_name) to count only non-NULL entries.- len()
- count()
- number()
- num()
The Correct Option is B
Solution and Explanation
used to count the number of rows that match a specified condition.
When used on a column, COUNT() counts only the non-NULL values.
It ignores any NULL entries in that column automatically.
len(), number(), and num() are not valid SQL aggregate functions.
len() exists in Python but not in SQL.
Therefore, the function that counts values ignoring NULLs is COUNT().
So, option (B) is correct.
Top Questions on SQL
- Write a function
Delete_Theatre()to input the value of Th_ID from the user and permanently delete the corresponding record from the THEATRE table in the CINEMA database.
Given:
Host: localhost, User: root, Password: Ex2025
Assume that you are working in the IT Department of a Creative Art Gallery (CAG), which sells different forms of art creations like Paintings, Sculptures etc. The data of Art Creations and Artists are kept in tables Articles and Artists respectively. Following are few records from these two tables:
(i) To display all the records from the Articles table in descending order of Price.
(ii) To display the details of Articles which were created in the year 2020.
(iii) To display the structure of the Artists table.
(iv-a) To display the name of all artists whose Article is Painting using Equi Join.
(iv-b) To display the name of all artists whose Article is 'Painting' using Natural JoinSuman has created a table named WORKER with a set of records to maintain the data of the construction sites, which consists of WID, WNAME, WAGE, HOURS, TYPE, and SITEID. After creating the table, she entered data in it, which is as follows :
- Nisha is assigned the task of maintaining the staff data of an organization. She has to store the details of the staff in the SQL table named EMPLOYEES with attributes as EMPNO, NAME, DEPARTMENT, BASICSAL to store Employee’s Identification Number, Name, Department, and Basic Salary respectively. There can be two or more Employees with the same name in the organization.
(i)
(a) Help Nisha to identify the attribute which should be designated as the PRIMARY KEY. Justify your answer.
OR
(b) Help Nisha to identify the constraint which should be applied to the attribute NAME such that the Employees’ Names cannot be left empty or NULL while entering the records but can have duplicate values.
(ii)
(a) Write the SQL command to change the size of the attribute BASICSAL in the table EMPLOYEES to allow the maximum value of 99999.99 to be stored in it.
OR
(b) Write the SQL command to delete the table EMPLOYEES. - Assertion (A): We can retrieve records from more than one table in MYSQL.
Reason (R): Foreign key is used to establish a relationship between two tables.
Questions Asked in CBSE CLASS XII exam
- Two wires of the same material and the same radius have their lengths in the ratio 2:3. They are connected in parallel to a battery which supplies a current of 15 A. Find the current through the wires.
- CBSE CLASS XII - 2025
- Current electricity
- $ \int \frac{e^{10 \log x} - e^{8 \log x}}{e^{6 \log x} - e^{5 \log x}} \, dx$ is equal to :
- CBSE CLASS XII - 2025
- Integration
- A reaction is of second order with respect to a reactant. How is the rate of reaction affected if the concentration of the reactant is (i) doubled, (ii) reduced to half?
- CBSE CLASS XII - 2025
- Order of Reaction
Rupal, Shanu and Trisha were partners in a firm sharing profits and losses in the ratio of 4:3:1. Their Balance Sheet as at 31st March, 2024 was as follows:
(i) Trisha's share of profit was entirely taken by Shanu.
(ii) Fixed assets were found to be undervalued by Rs 2,40,000.
(iii) Stock was revalued at Rs 2,00,000.
(iv) Goodwill of the firm was valued at Rs 8,00,000 on Trisha's retirement.
(v) The total capital of the new firm was fixed at Rs 16,00,000 which was adjusted according to the new profit sharing ratio of the partners. For this necessary cash was paid off or brought in by the partners as the case may be.
Prepare Revaluation Account and Partners' Capital Accounts.- CBSE CLASS XII - 2025
- Partnership Accounts
- Explain giving three reasons why tropics show greatest levels of species diversity.
- CBSE CLASS XII - 2025
- Biodiversity