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 dialect in sql?

888

How do I view a view in sql?

889

How do I run a script in sql developer?

899

What is group function in sql?

964

Is vs as in pl sql?

933

How many disk partitions should I have?

941

What is the difference between local and global temporary table?

987

what is the difference between truncate and delete statement? : Transact sql

1016

Inline the values in PL/SQL, what does it mean.?

1156

What is clustered index sql?

931

How to get list of all tables from a database?

1107

How many developers work on postgresql?

915

Is pl sql a programming language?

925

What is relationship? How many types of relationship are there?

1070

Why procedure is used in sql?

970