select max(rownum) from table

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

Question Posted / kart

Answer Posted / kart

Is This Answer Correct ?

65 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What are the types of subqueries?

1103

What is the difference between function and procedure in pl/sql?

1138

Who developed sql?

1101

what are the advantages of sql ? : Sql dba

1111

what are all the different types of indexes? : Sql dba

1107

Explian rowid, rownum?

1086

What is dba in sql? : SQL DBA

1095

Name some usages of database trigger?

1086

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1010

how to rename an existing column in a table? : Sql dba

1084

What is the purpose of the partition table?

1089

What is function and procedure?

1078

what is the syntax for using sql_variant_property? : Transact sql

1086

explain about mysql and its features. : Sql dba

1054

Why triggers are used?

1040