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

What is sql catalog?

1011

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

974

What is the left table in sql?

959

how do you know the version of your mysql server? : Sql dba

998

How many types of relationship are there?

1023

What are database links used for?

1038

What is dense_rank in sql?

965

What company owns postgresql?

1019

List the various privileges that a user can grant to another user?

1036

What are the limitations of sql express?

1064

List the different type of joins?

1058

Can we create table in function?

957

Can a composite key be null?

970

What programs use sql?

992

What does closing a cursor do?

1312