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

How do we accept inputs from user during runtime?

1012

Inline the values in PL/SQL, what does it mean.?

1172

Can we join same table in sql?

975

Compare sql & pl/sql

1062

Define sql delete statement.

967

What are % type and % rowtype?

990

How can I change database name in sql?

1021

how are mysql timestamps seen to a user? : Sql dba

1073

What is the difference between row level and statement level trigger?

972

Where can I learn sql for free?

949

Is stored procedure faster than query?

923

Can ddl statements be used in pl/sql?

1087

what is a record in a database ? : Sql dba

1014

What is the use of index in hive?

974

what is the use of set statement in tsql? : Transact sql

961