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 does sql developer connect to oracle database?

992

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1055

Explain ddl statements in pl/sql?

1001

Which is better join or inner query?

1035

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1035

Why query optimization is needed?

918

When is the update_statistics command used?

1105

Why join is faster than subquery?

1103

What can I use instead of union in sql?

958

how many tables will create when we create table, what are they? : Sql dba

1066

Cite the differences between execution of triggers and stored procedures?

1075

What is a system versioned table?

975

Can we call dml statement in function?

1045

What is a variable in sql?

994

Does group by remove duplicates?

1034