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 difference between explicit and implicit cursors in oracle?

1115

What is t sql in sql server?

1132

what is data manipulation language? : Sql dba

1068

how to include comments in sql statements? : Sql dba

999

Is left join and outer join same?

1116

what is primary key? : Sql dba

1080

How can triggers be used for the table auditing?

1117

What is difference between stored function and application function?

1290

What do you mean by query optimization?

1050

What is sql query limit?

1021

Is subquery faster than join?

1063

What is a join query?

1004

Is id a reserved word in sql?

1187

define sql update statement ? : Sql dba

1159

What is not null in sql?

1109