Informatics Practices
Which values will not be considered by SQL while executing the following statement?
SELECT COUNT(column name) FROM DEPARTMENT;
- Numeric value
- Text value
- Null value
- Date value
SQL Queries
3 Likes
Answer
Null value
Reason — The COUNT() function in SQL counts only non-null values in a column. It does not consider null values while executing the statement. Therefore, null values will not be counted by the COUNT() function in the given SQL statement.
Answered By
1 Like
Related Questions
Group functions can be applied to any numeric values, some text types and DATE values.
What will be the order of the data being sorted after the execution of given SQL query?
SELECT * FROM STUDENT ORDER BY ROLL_NO;- Custom Sort
- Descending
- Ascending
- None of these
Which of the following clauses is used to sort the result set?
- SORT BY
- GROUP BY
- ARRANGE BY
- ORDER BY
Which clause is used in query to place the condition on groups in MySQL?
- WHERE
- HAVING
- GROUP BY
- Both (i) & (ii)