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 meant by <> in sql?

888

what is user defined functions? : Sql dba

973

What does (*) mean in sql?

903

Can we rename a column in the output of sql query?

947

What is a natural join?

988

Is id a reserved word in sql?

1087

What is a trigger in sql?

1156

What makes a good primary key?

974

What is sql key?

917

Are stored procedures faster than dynamic sql?

977

What is sql select statement?

968

Why do we need cursors in pl sql?

999

What are synonyms in sql?

928

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

899

How do you create a unique index?

985