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
- 11357 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / nitin vartak
select enam ,eempno , (len(phoneno) - len(replace
(phoneno,',',''))) + 1 from TableName
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Can we connect to postgresql using sql developer?
How does a trigger work?
Why do we use partitions in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is ttitle and btitle?
What is the use of %rowtype?
What is the meaning of disabling a trigger?
what are date and time data types in mysql? : Sql dba
What is the usage of distinct keyword?
Explain aggregate functions are available there in sql?
What are primary key and foreign key and how they work?
Why we use pl sql?
Where is sql database stored?
Is delete faster than truncate?
Can we create table inside stored procedure?
