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 do I partition in sql?

1019

What is foreign key in sql with example?

974

how to drop an existing view in mysql? : Sql dba

1102

what are the differences between char and nchar? : Sql dba

1158

What are expressions?

1061

What is the maximum rows in csv?

977

How many types of index are there?

1098

Which sql statement is used to delete data from a database?

1003

What are different types of keys?

1171

Can we rollback delete command?

1036

How is a PL/SQL code compiled?

1282

How do I run a query in pl sql developer?

1048

What is serial sql?

1038

What is localdb mssqllocaldb?

1106

What are %type and %rowtype for?

1102