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

What is partition in sql query?

1044

What are the uses of sysdate and user keywords?

1148

What is memory optimized?

1132

What is cartesian join in sql?

1193

What will you get by the cursor attribute sql%rowcount?

1075

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1046

What are the types pl/sql code blocks?

1192

Is sql a programming?

1024

How do I upgrade sql?

1048

what is a database transaction? : Sql dba

1255

How many scalar data types are supported in pl/sql?

1102

what is a trigger in mysql? Define different types of trigger. : Sql dba

1112

What is view explain with example?

993

Explain clause in sql?

1070

What is an oracle stored procedure?

1113