Write a query to display the count of individual characters in a given string. e.g if the given string is "mesopotamia" , the output should be :
m 2
e 1
i 1
s 1
o 2
p 1
t 1
a 2
Solution:
select ind, count(ind)
from
(
select substr(given_string,rownum,1) ind
from
(
select 'mesopotamia' given_string from all_objects
)
where
rownum<=length(given_string)
)
group by ind
TIME_BUCKET group by time period
-
We all know how to sum up by year select
to_char(trunc(hiredate,'Y'),'YYYY') year, count(*) from scott.emp group by
trunc(hiredate,'Y') order by trunc(hire...
1 week ago
No comments:
Post a Comment