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
11041 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

how do you know if your mysql server is alive? : Sql dba

1027

What is a unique key and primary key and foreign key?

920

What does <> sql mean?

989

What does where 1 1 mean in sql?

981

What is auto increment feature in sql?

1070

How can we link a sql database to an existing android app?

983

Can there be more than one function with a similar name in a pl/sql block?

927

Does sql support programming?

1009

What is a sql*loader control file?

1167

How many scalar data types are supported in pl/sql?

978

Why is normalization important?

974

Which is better stored procedure or query?

922

What are pl/sql cursors?

993

Explain clause in sql?

963

What are sql indexes?

938