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

How do you optimize a query?

998

What is sql character function?

1079

Can we perform dml in function?

1067

What is a constraint?

1022

What is #table in sql?

1098

what is dbms? : Sql dba

994

How can we store rows in PL/SQL using array?

1219

What are the sql versions?

944

Is sql between inclusive?

1130

explain the options of myisamchk to improve the performance of a table. : Sql dba

1010

How do I find duplicates in sql?

929

How do I sort a table in sql?

1044

What is a primary key called that is made up of more than one field?

1351

Explain how to use transactions efficiently : transact sql

980

What is a unique constraint?

1073