Login to manage your account

Your email Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up

Which function returns the number of rows in a result set including those with NULL values in a column?

A COUNT(column)
B COUNT(*)
C SUM(column)
D TOTAL(*)

Answer

COUNT(*)

COUNT(*) counts rows. COUNT(column) counts only rows where that column is not NULL, which is a frequent source of unexpected results.

Login to manage your account

Your email id Please enter a valid email address.

Password Forgot Password?

Please enter a valid password.

OR

Don't have an account yet? Sign up as

Jobseeker

Employer