select name,length(replace(phno, ',')) from phno;

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

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

Answer Posted / ajit

select name,length(replace(phno, ','))
from phno;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the limitations of sql express?

989

What are functions in sql?

907

How can you load microsoft excel data into oracle? : aql loader

1130

How are sql commands classified?

1038

What is a table partition?

1042

Define commit?

946

What is serial sql?

923

How can we implement rollback or commit statement in a trigger?

981

What are the different types of dbmss?

967

What is the use of index in sql?

963

How do I upgrade sql?

951

What is use of trigger?

875

Describe different types of general function used in sql?

981

What are actual parameters and formal parameters?

1041

What is the difference between microsoft sql and mysql?

921