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 msql? : Sql dba

1040

How do I sort a table in sql?

1076

Is sql a scripting language?

1081

How do I run a program in pl sql?

1052

How do I clear the screen in sql plus?

1081

How many triggers can be applied on a table?

982

Explain what is rdbms?

1083

Where the sql database files are stored?

1069

Can we rollback after truncate?

1070

What is an emotional trigger?

1055

What is sql and its types?

1247

describe mysql connection using mysql binary. : Sql dba

1108

What are the parameter modes supported by pl/sql?

1147

How do you drop a trigger?

1033

What are all ddl commands?

1125