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 are tuples in sql?

1081

Can a primary key be a foreign key?

983

Is json a nosql?

933

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3019

What are the usages of sql?

1029

what is sql? : Sql dba

981

Why is normalization important?

988

What are the types of join and explain each?

1001

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

1034

how to get a list of indexes of an existing table? : Sql dba

934

Is it mandatory for the primary key to be given a value when a new record is inserted?

1162

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

1001

What are the 3 types of behavioral triggers?

1204

I need a function for a train ticket reservation please answer it thanks in advance

975

Explain commit, rollback and savepoint.

953