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

Answer Posted / ramaraju

select max(rownum) from table_name;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you add a column to a table?

598


Is it possible to create startup or shutdown trigger for on-schema?

579


What is clustered index sql?

502


What types of commands can be executed in sql*plus?

548


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

618






what is sql server agent? : Sql dba

599


What do you mean by stored procedures?

545


Explain polymorphism in pl/sql.

636


what is the difference between $message and $$message? : Sql dba

545


What is the main reason behind using an index?

551


Why select is used in sql?

514


describe transaction-safe table types in mysql : sql dba

502


Why are aggregate functions called so?

510


Is the primary key an index?

595


How does cross join work in sql?

533