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

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

Post New Answer

More SQL PLSQL Interview Questions

What is diff between bulk collect and forall

3 Answers   Metric Stream,


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

0 Answers  


What is where clause in sql?

0 Answers  


if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  


What is compilation error in pl sql?

0 Answers  






How do you remove duplicate records from a table?

0 Answers  


Main diff between varray and nested tablea

3 Answers   Polaris, TCS,


What is the unique index?

0 Answers  


in procedure how to return a value

3 Answers   Wipro,


what is an associative array with example?

1 Answers  


What is mutating error in pl sql?

0 Answers  


What is the least restrictive isolation level? : Transact sql

0 Answers  


Categories