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
11244 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 out parameter used for eventhough return statement can also be used in pl/sql?

1059

Why we use cross join?

938

What is the difference between mdf and ndf files?

1097

how can we find the number of rows in a table using mysql? : Sql dba

1069

Why function is used in sql?

926

Which language is used in sql?

1041

Is not null in sql?

966

What is the difference between subquery and correlated query?

1043

What is group by in sql?

1074

What is Collation Sensitivity ? What are the various type ?

937

What is the sql*loader? : aql loader

1039

What are the indexing methods?

1029

how to enter numeric values as hex numbers? : Sql dba

1047

Is ms sql traffic encrypted?

910

Why do we use procedures in sql?

1059