Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11031 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
Explain what is table in a database?
What is sql basics?
What is dbo in sql?
Which is faster joins or subqueries?
Can %notfound return null after a fetch?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What are the differences between implicit and explicit cursors?
What are the 3 modes of parameter?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
what is the difference between delete and truncate statement in sql? : Sql dba
Which is better stored procedure or query?
How to display the current date in sql?
How do you define a foreign key?
What are the types pl/sql code blocks?
what are tables and fields? : Sql dba
