select max(rownum) from table

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

Question Posted / l meher

Answer Posted / l meher

select max(rownum) from table_name;

Is This Answer Correct ?

24 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What jobs use sql?

1029

What is sql keyword?

1043

How do you use a while loop in pl sql?

1050

Is sql a dbms?

1059

What is sql rowcount?

1066

What are the different type of joins in sql?

997

What is an intersect?

1154

How is data stored in sql?

1098

Why we use join in sql?

1022

What is a pdo connection?

1110

How do you declare a variable in pl sql?

1066

What are different joins used in sql?

1100

What is sql analyzer?

1059

what is the command used to fetch first 5 characters of the string? : Sql dba

1679

What does joining a thread mean?

1072