select rownum from tablename;

With out using count() function. How to the find total
number of rows in a table?

Question Posted / ramachandran

Answer Posted / ramachandran

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Are there any features that are decommissioned in 11g that are not present in 11g?

2139

What are transaction and its controls?

1033

Are stored procedures faster than dynamic sql?

1024

What are the sql commands?

1161

how many values can the set function of mysql take? : Sql dba

977

What are expressions?

1002

What is difference between sql and excel?

1080

What is synchronized subquery?

1158

Why do we use function in pl sql?

1054

Is sql between inclusive?

1117

What does data normalization mean?

947

Is sqlite free?

961

What is the difference between microsoft access and sql?

1012

What are the events on which a database trigger can be based?

1178

How can we debug in PL/SQL?

1127