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 are the types of join and explain each? : Sql dba

1035

What is the difference between function and procedure in pl/sql?

1076

What is a primary key example?

956

What is sql comments?

1072

What is the most restrictive isolation level? : Transact sql

1081

Is full outer join same as cross join?

964

What is column?

983

What does truncate mean in sql?

1017

What is the use of count (*) in sql?

1051

Is it possible to create startup or shutdown trigger for on-schema?

1021

How does a trigger work?

1063

How much ram can sql express use?

980

Does sql view stored data?

949

What type of database is cloud sql?

1095

How do I install sql?

986