select count(1) from <table_name>; By this also we can count no of

How do u count no of rows in a table?

Question Posted / bj

Answer Posted / bj

select count(1) from <table_name>;

By this also we can count no of rows in a table.

Is This Answer Correct ?

19 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is bcp? When is it used?

1182

What is thread join () in threading?

1057

What is file based approach?

999

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116

how to create a new view in mysql? : Sql dba

986

Is mariadb nosql?

1090

What is recursive stored procedure?

1141

What are pl/sql cursor exceptions?

1166

How do you modify a column in sql?

1052

What does t sql mean?

1002

what does the t-sql command ident_incr does? : Transact sql

1125

what happens if null values are involved in expressions? : Sql dba

1093

explain the difference between bool, tinyint and bit. : Sql dba

1063

What is a scalar value in sql?

1122

What pl/sql package consists of?

1135