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

Do we need to rebuild index after truncate?

985

How to install oracle sql developer?

1000

how to see the create table statement of an existing table? : Sql dba

959

What are different types of queries in sql?

1064

define sql insert statement ? : Sql dba

983

Explain two easy sql optimizations.

975

How many types of literals are available in pl sql?

1059

Which command is used to delete a package?

1110

explain the difference between myisam static and myisam dynamic. : Sql dba

896

how to escape special characters in sql statements? : Sql dba

988

What trigger means?

933

What is file based approach?

890

What are the types of sql commands?

1038

What is sap sql anywhere?

994

how to fetch alternate records from a table? : Sql dba

1066