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

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1015

Sql technical questions

1280

Explain the difference between rename and alias?

1010

What is database white box testing and black box testing?

1111

what is 'mysqlimport'? : Sql dba

1051

Can we use delete in merge statement?

1039

Is sql similar to python?

973

Define the select into statement.

1057

What is difference between pls_integer and integer?

958

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209

What is time based sql injection?

958

Explain what is sql?

1115

What is primary key secondary key alternate key candidate key?

1037

Is sql microsoft?

1055

Does sql between include endpoints?

1012