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 I view tables in sql developer?

960

How do you optimize a query?

1011

What is record type in pl sql?

1001

how to create a table index in mysql? : Sql dba

1067

What is substitution variable?

1056

How subquery works in sql?

1075

how mysql optimizes distinct? : Sql dba

1086

What is the purpose of primary key?

1033

What is a natural join sql?

993

Explain lock escalation? : Transact sql

1209

Is trigger a stored procedure?

938

What is oracle sql developer?

1072

What is the use of double ampersand (&&) in sql queries? Give an example

1146

discuss about myisam index statistics collection. : Sql dba

960

What is the use of sqldataadapter?

981