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
- 11588 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
What does count (*) mean?
Can a table contain multiple primary key’s?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is not in sql?
How many subqueries can be nested in a statement?
How to process query result in pl/sql?
What is a column in a table?
what is unique key constraint? : Sql dba
Which are the different character-manipulation functions in sql?
How do you delete duplicates in sql query using rowid?
what is the difference between char and varchar data types? : Sql dba
Advantages and disadvantages of stored procedure?
What is structural independence and why is it important?
Where can I learn sql for free?
