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

Is grant a ddl statement?

855

explain mysql aggregate functions. : Sql dba

941

How run sql*plus commands that are stored in a local file?

976

explain the delete statements in sql

979

Can we rename a column in the output of sql query?

949

What is the difference between sql, mysql and sql server?

1016

Is vs as in pl sql?

935

What view means?

931

What is faster join or subquery?

962

What's the procedure?

867

What is difference between procedure and trigger?

919

how many columns can be used for creating index? : Sql dba

899

What is clustered index sql?

934

What is sqlerrd?

921

Is sql low level language?

963