select max(rownum) from table

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

Question Posted / l meher

11 Answers
29226 Views
TCS, Tesco, I also Faced
E-Mail Answers

Answer Posted / l meher

select max(rownum) from table_name;

Is This Answer Correct ?

24 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a stored procedure in sql with example?

1204

How do I turn a list into a table?

1013

Does varchar need length?

1050

What is pragma in sql?

1128

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1080

How to fix oracle error ora-00942: table or view does not exist

1084

What is the difference between explicit and implicit cursors in oracle?

1116

What is sqlerrd?

1016

What is a null value?

1191

What is tuple in sql?

1144

What pl/sql package consists of?

1137

What is sql and how does it work?

1252

Does google use sql?

1008

what is the different between now() and current_date()? : Sql dba

1077

what are date and time functions in mysql? : Sql dba

1028