select count(column_name) from table

i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6

Question Posted / ajmal khan

8 Answers
11602 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / ajmal khan

select count(column_name) from table_name;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference sql and mysql?

1038

what is the difference between a web-garden and a web-farm? : Sql dba

1148

Why do we use cursors?

1047

What is procedure and function?

1035

Can we use threading in pl/sql?

1101

explain normalization concept? : Sql dba

1092

What are the two different parts of the pl/sql packages?

1143

What is execution plan in sql?

1092

What is gpt format?

993

What is sql and explain its components?

1119

What is sql character function?

1153

how to escape special characters in sql statements? : Sql dba

1085

Which nosql database is best?

1025

What are the different types of triggers?

1198

How do you declare a user-defined exception?

1080