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

What is meaning of <> in sql?

587

What does count (*) mean?

530

What is the difference between count 1 and count (*) in a sql query?

504

What do you know by pl/sql cursors?

570

What is a temp table?

571

what is unique key constraint? : Sql dba

574

What is difference between my sql and sql?

532

how to check myisam tables for errors? : Sql dba

608

How to read/write files from pl/sql?

582

How many databases can sql express handle?

536

how to get a list of all tables in a database? : Sql dba

513

Can we rollback truncate?

544

What is sql dialect?

531

what is union? : Sql dba

586

How can you select unique records from a table?

522