What does count (*) do in sql?



What does count (*) do in sql?..

Answer / Raisuddin Khan

In SQL, 'COUNT(*)' is a SQL aggregate function that returns the number of rows within a result set. Unlike COUNT(), COUNT(*) counts all rows, regardless of whether they are NULL or not.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is string data type in sql?

1 Answers  


what is 'trigger' in sql? : Sql dba

1 Answers  


Why do we need a foreign key?

1 Answers  


What is left join in postgresql?

1 Answers  


I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,


How to execute OS(operating system) command from pl/sql?

3 Answers  


how to create a new table by selecting rows from another table in mysql? : Sql dba

1 Answers  


find the third highest salary?

23 Answers  


I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  


Are dml statements autocommit?

1 Answers  


Can a key be both primary and foreign?

1 Answers  


How do you update a table in sql?

1 Answers  


Categories