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

Can ddl statements be used in pl/sql?

1147

Explain spool.

1186

What are the query optimization techniques?

941

What is memory optimized?

1090

explain advantages of myisam over innodb? : Sql dba

1071

What is data type in database?

1000

What is a data manipulation language?

1028

What is secondary key?

949

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1132

What are the different types of tables in sql?

1010

How to look at the current sql*plus system settings?

1157

What is crud diagram?

952

What is composite primary key in sql?

1002

What is the most important ddl statements in sql are?

1000

What is the sql case statement?

1011