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 pl sql commands?

558

What is break?

620

How long it takes to learn pl sql?

533

How to display the records between two range in Oracle SQL Plus?

641

What is meant by user defined function?

581

Is left join faster than join?

549

What are the built in functions of sql?

565

Is inner join same as self join?

580

How to run sql functions in pl/sql?

538

What is sql used for?

647

What is an ndf file?

534

What are the syntax and use of the coalesce function?

553

Explain the difference between triggers and constraints?

521

Define tables and fields in a database

646

How delete a row in sql?

535