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 'mysqlimport'? : Sql dba

1041

How do I start pl sql?

942

what is the difference difference between procedure and packages

10387

What is the limitation on the block size of pl/sql?

980

What is clause?

1140

How do I edit a stored procedure?

988

what is a relationship and what are they? : Sql dba

1093

What is an inner join sql?

1021

How do I install sql?

985

How to select random rows from a table?

1071

Explain the difference between sql and mysql.

1057

What is the difference between nested table and varray?

996

What is the difference between nvl function, ifnull function, and isnull function?

1101

What is normalization? How many normalization forms are there?

1080

What are the different types of database management systems?

995