select sum(1) from table

how to find count rows in table without count function?

Question Posted / anil kumar

Answer Posted / anil kumar

select sum(1) from table_name;

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does sharding mean?

531

What is the difference between a primary key & a unique key?

583

Can we insert data in view oracle?

529

Why do we use coalesce function in oracle?

618

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1434

In what script is snap$ created? In what script is the scott/tiger schema created?

2235

What is ordinary table in oracle?

643

What are the different oracle database objects?

577

Explain what are the different type of segments?

572

State the difference between a primary key and foreign key?

506

How to start a specific oracle instance?

573

How to drop a stored function?

670

What is meant by joins? List out the types of joins.

517

what is meant by magic query

1764

Differentiate between function and procedure in oracle.

556