select max(rownum) from table-name; Here rownum is a keyword which can g

With out using count() function. How to the find total
number of rows in a table?

Question Posted / subbarayulu neela

Answer Posted / subbarayulu neela

select max(rownum) from table-name;

Here rownum is a keyword which can gives unique number for
individual rows.

Is This Answer Correct ?

35 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is java sql package?

1099

Is sql injection illegal?

1030

What is difference between sql and mysql?

1137

what is sql? : Sql dba

1030

How do you define a foreign key?

1010

Is sql free?

975

What are the possible values that can be stored in a boolean data field?

1006

Why do we need cursor in pl sql?

1140

Is subquery faster than join?

1019

Why is pl sql used?

991

how do you control the max size of a heap table? : Sql dba

987

Why do we use %rowtype & %type in plsql?

1055

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1022

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1005

what are set operators in sql? : Sql dba

1058