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

Answer Posted / ramachandran

select rownum from tablename;

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you sum a count in sql?

549


What is pl sql collection?

514


What is the basic structure of an sql?

564


What is record type in pl sql?

533


What is the advantage of index in sql?

532






What does trigger mean in psychology?

528


Can pl sql procedure have a return statement?

545


How do you create a db file?

512


What is Materialized View? In What Scenario we Use Materialized View?

8504


Who developed sql?

563


Why function is used in sql?

510


What is the most important ddl statements in sql are?

516


Can dml statements be used in pl/sql?

568


How do you copy a table in sql?

553


How to take user input in pl sql?

696