select sum(1) from table

How to count the no of records of a table without using
COUNT function?

Question Posted / satya

Answer Posted / satya

select sum(1) from table_name;

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is mdb stand for?

1003

Why we use pl sql?

955

How do you add a column to a table?

1050

What do we need to check in database testing?

1014

is mysql query is case sensitive? : Sql dba

1088

Is coalesce faster than isnull?

962

What is PL/SQL Records?

1181

What is sql entity?

1090

How to raise user-defined exception with custom sqlerrm ?

1121

What is procedure and function in sql?

992

What is difference between sql and oracle?

1112

Explain architecture of sql server notification services?

1054

What is a left inner join?

1011

What is oracle and pl sql?

1115

What is lexical units in pl sql?

1139