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 procedure in pl sql?

1048

what is sql profiler? : Sql dba

1050

Is sql procedural language?

969

what is a primary key? : Sql dba

1038

What is mutating sql table?

1116

what are the differences between binary and varbinary? : Sql dba

1047

Explain select statements in sql?

1059

What are the different types of joins in sql?

1797

what are null values? : Sql dba

959

Which command is used to call a stored procedure?

1002

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1210

What is equi join in sql?

1082

Can we use pl sql in mysql?

1016

What are the advantages of sql? Explain

1107

What is rownum in sql?

1046