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

how to drop an existing view in mysql? : Sql dba

565


Is sqlite thread safe?

603


How do I truncate a sql log file?

530


explain normalization concept? : Sql dba

584


what is the difference between truncate and delete statement? : Transact sql

542






What is your daily office routine?

1808


what is bcp? When does it used? : Sql dba

519


Is sql pronounced sequel or sql?

736


What are analytic functions in sql?

547


Is vs as in pl sql?

488


Why are indexes and views important to an organization?

525


What is auto increment feature in sql?

616


Why truncate is faster than delete?

558


Can we use threading in pl/sql?

515


What is data control language?

528