select max(rownum)from table_name; this will also give number of rows in y

How do u count no of rows in a table?

Question Posted / prakash kumar

Answer Posted / prakash kumar

select max(rownum)from table_name;
this will also give number of rows in your table

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Where do we use pl sql?

555

What does pragma mean?

509

What are the qualities of 2nf?

546

what is sp_pkeys? : Transact sql

699

How do I get sql certification?

528

Why does sql need a server?

564

What is the non-clustered index in sql?

588

Can ddl statements be used in pl/sql?

594

Is full outer join same as cross join?

503

What is an intersect?

655

What is difference between my sql and sql?

530

What is the usage of when clause in trigger?

567

What is a variable in sql?

514

What is the use of partition by in sql?

517

Explain what is an index?

592