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

Answer Posted / manjunath u

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

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is string join?

550


How do you change a value in sql?

554


what are the advantages of using stored procedures? : Sql dba

613


what is a primary key? : Sql dba

552


Can a commit statement be executed as part of a trigger?

598






What is the difference between sql and isql*plus?

511


What is sql catalog?

560


what is sp_pkeys? : Transact sql

699


What is asqueryable?

529


What is difference between primary and secondary key?

515


explain commit and rollback in mysql : sql dba

545


Can we call dml statement in function?

540


Why select is used in sql?

514


what is a database transaction? : Sql dba

581


What is %type in pl sql?

540