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 the maximum number of rows in sql table?

741

What is sql*loader and what is it used for?

742

Is postgresql a server?

736

Can we use join in subquery?

775

What are types of joins?

703

Can a primary key be a foreign key?

750

Do we need commit after truncate?

813

How many postgresql users are there, worldwide?

779

what is 'mysqlshow'? : Sql dba

748

What is the use of stored procedures?

704

how would concatenate strings in mysql? : Sql dba

740

Is sql a backend language?

844

Can we commit inside a trigger?

732

difference between anonymous blocks and sub-programs.

818

how to use 'mysql' to run sql statements? : Sql dba

738