Question discussion

In SQL, COUNT(*) differs from COUNT(column_name) in that COUNT(*):

148Medium DSSSB TGT Computer Science 0 replies
In SQL, COUNT(*) differs from COUNT(column_name) in that COUNT(*):
  • AIgnores duplicate rows
  • BCounts all rows, including those with NULL in the specified column
  • COnly counts numeric columns
  • DReturns an error if the table is empty
Correct answer: B

Discussion 0

Nobody has replied yet. Start the discussion!