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

give the syntax of grant and revoke commands? : Sql dba

1090

How do I partition a table in sql?

1045

What is record variable?

925

What is a temp table?

950

Does mysql support pl sql?

1099

What is foreign key sql?

947

How does postgresql compare to mysql?

989

What is the starting oracle error number? What is meant by forward declaration in functions?

940

Why do we use joins?

986

Why primary key is required?

939

Is left join same as join?

939

what is the difference between undefined value and null value? : Sql dba

1041

Why stored procedure is faster than query?

951

What is the difference between rename and alias?

1270

How we can update the view?

1007