With out using count() function. How to the find total number of rows in a tab

With out using count() function. How to the find total
number of rows in a table?

Question Posted / balaji g

Answers were Sorted based on User's Feedback

With out using count() function. How to the find total number of rows in a table?..

Answer / subbarayulu neela

select max(rownum) from table-name;

Here rownum is a keyword which can gives unique number for
individual rows.

Is This Answer Correct ?

35 Yes

2 No

With out using count() function. How to the find total number of rows in a table?..

Answer / saurabh

select sum(1) from table-name

Is This Answer Correct ?

26 Yes

4 No

With out using count() function. How to the find total number of rows in a table?..

Answer / manjunath u

rownum is one of the option, can deal with sequence also

Is This Answer Correct ?

4 Yes

2 No

With out using count() function. How to the find total number of rows in a table?..

Answer / ramaraju

select max(rownum) from table_name;

Is This Answer Correct ?

0 Yes

0 No

With out using count() function. How to the find total number of rows in a table?..

Answer / balaji g

please help me query answare

Is This Answer Correct ?

7 Yes

9 No

With out using count() function. How to the find total number of rows in a table?..

Answer / ramachandran

select rownum from tablename;

Is This Answer Correct ?

1 Yes

3 No