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

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1006

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1871

What is the implicit cursor in oracle?

1036

Can select statements be used on views in oracle?

982

Explain about functional dependency and its relation with table design?

952

What are the various oracle database objects?

1091

How to sort the query output in oracle?

968

what are the default admin accounts in Oracle 10g ?

917

How to manage transaction isolation level?

949

How do we get field detail of a table?

1020

How different is ms access and oracle?

987

What is ASM (Automatic Storage Management) in Oracle?

1122

What is tns service name?

1072

What is an oracle recycle bin?

930

what's query optimization and without use of IN AND Exist can we get another way data from query

2086