select length(phoneno)-length(replace(phoneno,','))+1 as TOTALCOU

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

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

Answer Posted / sarath

select length(phoneno)-length(replace(phoneno,','))+1 as TOTALCOUNT from <tablename>

For few friends who sent count(*) I wanna say something that
Its a SINGLE (FIELD VALUE)STRING CONTAINING MULTIPLE PHONENOs

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is cursor explain with example?

964

How does index help in query performance?

1013

how to present a past time in hours, minutes and seconds? : Sql dba

988

What are stored procedures used for?

986

Can I learn sql in a week?

1043

Is sql a case sensitive language?

915

Explain the advantages and disadvantages of stored procedure?

1132

What are field types?

973

What does where 1 1 mean in sql?

1019

what are date and time intervals? : Sql dba

1033

What is normalization in a database?

1142

What is oracle sql developer?

1029

Can we use rowid as primary key?

965

what is 'mysqladmin' in mysql? : Sql dba

1009

Can two tables have same primary key?

953