select count(*) from table will give the number of rows in the table incl

How do u count no of rows in a table?

Question Posted / gunturajesh

Answer Posted / gunturajesh

select count(*) from table will give the number of rows in
the table including null values

Is This Answer Correct ?

32 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is the use of friend function? : Sql dba

535

What is a common use of group by in sql?

588

What is rank () in sql?

529

What is a trigger in sql?

634

What is procedure explain with program?

546

What are different clauses used in sql?

581

explain commit and rollback in mysql : sql dba

540

what are the different tables present in mysql? : Sql dba

500

Which sql statement is used to delete data from a database?

461

What is an exception in PL/SQL? What are the two types of exceptions?

620

Is mariadb a nosql database?

532

Why are aggregate functions called so?

507

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

538

What are inbuilt functions in sql?

595

Can we join more than 2 tables in sql?

487