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 are the types of join and explain each?

1031

How do I quit sql?

950

How to convert comma separated string to array in pl/sql?

1173

how to increment dates by 1 in mysql? : Sql dba

974

What is the difference between clustered and non-clustered indexes?

1085

how to create a table index in mysql? : Sql dba

1057

How many sql statements are used?

1006

Is sql a backend language?

1090

What are all types of user defined functions?

1073

I need a function for a train ticket reservation please answer it thanks in advance

1022

How to get unique records from a table?

959

Is ms sql is free?

1020

What is a schema? How is it useful in sql servers?

1114

What is right join sql?

960

What does pl sql stand for?

1109