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 are the main features of cursor?

1108

What are the usages of sql?

1098

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1182

What is a full join sql?

1101

What is sql*plus?

1120

What are the operators in sql?

1067

What is latest version of sql?

1100

what are the advantages of mysql in comparison to oracle? : Sql dba

1044

Does inner join remove duplicates?

992

What is a record in a database?

1100

Can we connect to postgresql using sql developer?

1046

Do we need commit after truncate?

1134

Which is better trigger or stored procedure?

1012

Explain the select statement in sql?

1179

what are different types of collation sensitivity? : Sql dba

1114