How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1
please give any idea on that
Answer Posted / amit kumar
firstaly take string in any variable. then index with start(')
and end(');then u got the full string length. after that u
substring one character and add (:1) and so on to reach the
last character..
and finally u get result.
bye
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What are dml triggers and types of dml triggers?
What is the difference between delete and truncate statements?
List down some advantages of sql stored procedure?
What does this statement do @@rowcount?
How to get the query of a table in sql server?
What is amo? : sql server analysis services, ssas
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Difference between drill down and drill through report.
What is the difference between stored procedure and functions?
What is the difference between implicit and explicit transaction?
Can we deploy SSRS reports on our personal website?
Explain concepts of analysis services?
Mention the differences between having and where clause.
What are the benefits of normalization?
How to connect of datebase with sql express.?