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

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1133

What is the most important ddl statements in sql are?

1042

how to check server status with 'mysqladmin'? : Sql dba

1134

What do you mean by query optimization?

1051

What found sql?

995

How to write a query to show the details of a student from students table whose

1063

Is inner join faster than left join?

1252

How to look at the current sql*plus system settings?

1216

Is pl sql a scripting language?

1082

When can we use the where clause and the having clause?

1087

Can a foreign key be a duplicate?

967

Explain the uses of a database trigger?

1089

What are commit, rollback, and savepoint?

1049

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1226

How to run sql*plus commands in sql developer?

1207