select count(*) from table

How do u count no of rows in a table?

Question Posted / siri

Answer Posted / siri

select count(*) from table_name

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sqlite free?

1022

What jobs use sql?

1030

Can we write ddl statements in functions?

1182

How do you create a db file?

1066

What is over () in sql?

1011

What is db journal file?

1152

what is the difference between join and union? : Sql dba

1195

Why do we use joins?

1097

Why do we go for stored procedures?

1123

What are the parts of a basic sql query?

1010

What are records give examples?

1050

In a distributed database system, can we execute two queries simultaneously?

1152

What can sql server reporting services do?

1162

What are tables in sql?

1115

State few characteristics of pl/sql?

1021