select sum(1) from table

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

Question Posted / satya

11 Answers
28878 Views
TCS, Tesco, I also Faced
E-Mail Answers

Answer Posted / satya

select sum(1) from table_name;

Is This Answer Correct ?

4 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you know if a relationship is 2nf?

955

What are the packages in pl sql?

1022

What is forward declaration in pl sql?

1088

What's the difference between inner join and left join?

1008

What is the primary use of normalization?

1017

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4017

what is log shipping? : Sql dba

1130

How much ram can sql express use?

995

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1046

What is sql exception?

980

What are stored procedures used for?

1010

What does pl sql stand for?

1125

Explain what is an index?

1066

What are the key differences between SQL and PL SQL?

1223

how to get a list of all tables in a database? : Sql dba

982