select max(rownum) from table

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

Question Posted / ramaraju

Answer Posted / ramaraju

select max(rownum) from table_name;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does oracle use sql?

683

Why is a primary key important?

726

What is identity column in sql server?

717

what are the features and advantages of object-oriented programming? : Sql dba

727

What is the difference between unique and primary key constraints?

769

What are keys in sql?

721

What is the process of debugging?

740

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

654

Can we use commit inside a trigger?

763

What are the different ddl commands in sql?

739

How to select unique records from a table?

761

Can we use the cursor's to create the collection in PL/SQL?

694

What is oracle and pl sql?

827

What are aggregate and scalar functions?

722

How to write pl sql program in mysql command prompt?

709