select rownum from table

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

Question Posted / sudhakar & co

Answer Posted / sudhakar & co

select rownum from table_name;

Is This Answer Correct ?

1 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is count * in sql?

997

Are pl sql variables case sensitive?

1046

How many times can we commit in a loop?

1017

which operator is used in query for pattern matching? : Sql dba

1005

What is equi join in sql?

1073

What does subquery mean in sql?

1051

Can pl sql procedure have a return statement?

1030

What is compound trigger?

1036

What is record data type?

916

Explain the uses of a database trigger?

1043

What is the sql case statement?

1003

how to extract a unit value from a date and time? : Sql dba

990

How do I run pl sql in sql developer?

1116

What is a constraint?

1022

What is date functions?

1028