select count(column_name) from table_name; if u want to count number of

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 / venkat

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

Answer Posted / venkat

select count(column_name) from table_name;

if u want to count number of phone numbers then use below
from emp table

select count(phno) from emp;

Is This Answer Correct ?

3 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is natural join in sql?

1045

How do I view a table in sql?

1043

what is a materialized view? : Sql dba

1133

Can a key be both primary and foreign?

1055

how is myisam table stored? : Sql dba

1099

what is msql? : Sql dba

1044

Which certification is best for sql?

1042

What are the built in functions of sql?

1096

What is the purpose of the sql select top clause?

1208

Can a table have no primary key?

1113

Why do we need sharding?

1050

Which are the different character-manipulation functions in sql?

1113

What is inner join in sql?

1139

What is schema in sql example?

1282

Is it possible to read/write files to-and-from PL/SQL?

1151