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
- 8 Answers
- 10194 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
What are expressions?
How can triggers be used for the table auditing?
Name three sql operations that perform a sort.
Which is faster joins or subqueries?
How do you write an inner join query?
What is sql and how does it work?
what are the type of locks ? : Sql dba
How do I upgrade sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
what is timestamp in mysql? : Sql dba
Why use triggers in sql?
what is the syntax for using sql_variant_property? : Transact sql
What are the types of join in sql?
What is sql rowcount?
How do I view an execution plan in sql?
