how do u know the total no of rows in a table?

Question Posted / jakki

Answers were Sorted based on User's Feedback

how do u know the total no of rows in a table?..

Answer / rajasekar

Select count(*) from table

Is This Answer Correct ?

13 Yes

0 No

how do u know the total no of rows in a table?..

Answer / ajeet singh

select count(*) from <tablename>;

Is This Answer Correct ?

3 Yes

0 No

how do u know the total no of rows in a table?..

Answer / mohd akhtar

select sum(1) from emp

Is This Answer Correct ?

4 Yes

3 No

how do u know the total no of rows in a table?..

Answer / javid khan

select count(*) from table;

Is This Answer Correct ?

1 Yes

0 No

how do u know the total no of rows in a table?..

Answer / kamala k n

select count(*) from table name

Is This Answer Correct ?

0 Yes

0 No

how do u know the total no of rows in a table?..

Answer / gurudatt

better way is to use the sys.indexes table where it gives the total no rows for each table.

Is This Answer Correct ?

0 Yes

1 No