select max(rownum) from table

How to count the no of records of a table without using
COUNT function?

Question Posted / kart

Answer Posted / kart

Is This Answer Correct ?

65 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what is rollback? : Sql dba

1040

Can I join the same table twice?

1006

How does cross join work in sql?

971

What are commit, rollback, and savepoint?

954

How can you view the errors encountered in a trigger?

924

What are the benefits of stored procedures?

1017

What is cursor in pl sql?

1072

Does sql backup shrink transaction log?

933

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1023

How do you update f as m and m as f from the below table testtable?

1809

What is before trigger?

954

What are the constraints available in sql?

1013

What are the triggers associated with image items?

1010

How many types of triggers are there in pl sql?

1032

Is join and inner join the same?

958