select max(rownum) from table

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

Question Posted / sandeep

Answer Posted / sandeep

select max(rownum) from table_name;

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how to write date and time literals? : Sql dba

913

How global cursor can be declare with dynamic trigger ?

2146

What is materialized view. What are different methods of refresh?

1330

What are the types of queries in sql?

1015

Can a composite key be null?

910

Do ddl statements need commit?

922

What are the most important ddl statements in sql?

1025

Why is theta join required?

1080

What is before trigger?

946

how do you control the max size of a heap table? : Sql dba

921

Can we rollback after truncate?

980

What is null in pl/sql?

1022

What is the use of & in pl sql?

985

How to start oracle sql developer?

984

how do you know if your mysql server is alive? : Sql dba

1025