select max(rownum) from table

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

Question Posted / ramaraju

Answer Posted / ramaraju

select max(rownum) from table_name;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a recursive join sql?

1027

What is a crud api?

903

Is it possible to sort a column using a column alias?

994

Explain correlated query work?

992

Why schema is used in sql?

987

What is cursor in pl sql?

1052

What are all the ddl commands?

1118

What are the three pl sql block types?

949

How do I add a primary key to a table?

973

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1135

What is the need of merge statement?

989

What is the difference between functions, procedures, and packages in pl/sql?

975

What are the different types of tables in sql?

931

Can we create clustered index without primary key?

901

What is partition by in sql?

1002