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 the maximum size of sqlite database?

1040

Which table is left in join?

914

What is forward declaration in pl sql?

1006

What is sql clause?

993

What is ttitle and btitle?

1006

What is primary key and foreign key?

916

Why primary key is required?

936

What is the purpose of the sql select top clause?

1019

What if we write return in procedure?

1334

What is crud sql?

921

What is column?

940

Why do we need sharding?

936

What is scalar function?

999

What is null in pl/sql?

1022

Does sql profiler affect performance?

940