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

How to look at the current sql*plus system settings?

606

How to get unique records from a table?

525

What is a dirty read sql?

487

What is sql engine in oracle?

524

What are secondary keys?

563

What is bulk compiling in pl/sql.?

611

how to include character strings in sql statements? : Sql dba

556

Which are the different character-manipulation functions in sql?

550

Can we call a function containing dml statements in a select query?

546

Explain 3 basic parts of a trigger.

843

Why do we create views in sql?

561

How to add, remove, modify users using sql?

563

how to concatenate two character strings? : Sql dba

556

what is meant by nl2br()? : Sql dba

566

Does a user_objects view have an entry for a trigger?

571