rownum is one of the option, can deal with sequence also

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

Question Posted / manjunath u

Answer Posted / manjunath u

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and left join?

978

What is out parameter used for eventhough return statement can also be used in pl/sql?

1065

what is myisam? : Sql dba

1070

What are different types of functions in sql?

998

How does sql store data?

898

what are the join types in tsql? : Transact sql

1058

What are stuff and replace function?

1071

What is left join in sql?

1043

What is oracle pl sql developer?

975

How to use distinct and count in sql query? Explain

1010

Is it possible to update views?

954

Can cursors be part of a trigger body?

1633

What is difference sql and mysql?

972

What is rtm in testing?

1099

tell me about various levels of constraint. : Sql dba

1031