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

Give the order of sql select?

1133

Mention what is the use of function "module procedure" in pl/sql?

1045

Can we call procedure in select statement?

1049

Can we use joins in subquery?

1156

How can I tell if sql is running?

1056

What is a temp table?

1020

What is t-sql? : Transact sql

980

How do you run a query?

989

How do I start pl sql?

942

what are properties of a transaction? : Sql dba

1088

What are stored procedures in mysql?

1014

Is sql injection illegal?

1012

Why is sql important?

1098

Which is faster count (*) or count 1?

1024

What does closing a cursor do?

1313