select max(rownum) from table

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

Question Posted / l meher

Answer Posted / l meher

select max(rownum) from table_name;

Is This Answer Correct ?

24 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is it possible to link two groups inside a cross products after the cross products group has been created?

953

how to return query output in html format? : Sql dba

1018

What is #table in sql?

994

How does left join work in sql?

938

How can I change database name in sql?

1000

What is the difference between database trigger and stored procedure?

1005

what is the bond code in materialized view?

2930

what is self-join? : Sql dba

1051

How to call shell script from pl sql procedure?

1174

Can we join 3 tables in sql?

954

What is the difference between rename and alias?

1267

Enlist some predefined exceptions?

993

What are two statement types in sql?

1028

What is a pragma statement?

1200

how do you know the version of your mysql server? : Sql dba

935