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 you select unique values in sql?

494

Does sql full backup truncate logs?

522

How does index help in query performance?

554

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

573

What is mdf ldf and ndf?

551

how do you know if your mysql server is alive? : Sql dba

585

What are stored procedures in mysql?

552

What are the different sql commands?

505

What is partition by in sql?

564

What is a table in a database?

566

How many joins can you have in sql?

505

what is cross join? : Sql dba

565

What are tuples in sql?

555

What is the difference between delete, truncate and drop command?

541

How many types of triggers are there in pl sql?

568