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

How can one get sql*loader to commit only at the end of the load file? : aql loader

557

what are the differences between require and include, include_once and require_once? : Sql dba

519

What is normalization in sql?

519

Can I join the same table twice?

522

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

563

What is sql performance tuning?

487

What is the reports view in oracle sql developer?

535

What is mutating trigger?

570

What is sql mysql pl sql oracle?

561

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

490

what are myisam tables? : Sql dba

541

What is right join sql?

530

What is pivot table in sql?

518

What normalization means?

520

What is foreign key and example?

501