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

Name three sql operations that perform a sort.

786


What are sql constraints?

788


what is the difference between myisam static and myisam dynamic? : Sql dba

766


What does the argument [or replace] do?

807


What is sqlexception in java?

731






Do we need to rebuild index after truncate?

700


Write the alter statement to enable all the triggers on the t.students table.

847


What is the most common sql injection tool?

733


What is a record in pl/sql?

763


What is the difference between inner join and left join?

735


Explain what is a view?

795


What is application trigger?

733


What do you mean by query optimization?

727


What is difference between procedure and trigger?

669


How is use pl and sql?

733