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

State and explain the different types of data models?

944

What is Reduced List of Values?

2166

Explain the use of rows option in exp command.

1092

What is materialized view in Oracle?

1074

Explain an exception and its types?

1073

11. Display the client number and name and the client number and name of the person who referred that client.

2339

How to define a cusotmer as a supplier in ORACLE R12

2232

what is insert all statement in sql

6519

What are the uses of linked server and explain it in detail?

1061

How would you change old and new values in an insert, delete and update triggers?

1022

What is instant client oracle?

1021

Can we create database in oracle using command line ?

1088

How to use "if" statements on multiple conditions?

1174

How to convert characters to numbers in oracle?

1065

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

1918