Problem: Write an SQL query to convert a given decimal number to its binary equivqlent.
Solution:
select
reverse(max(replace(sys_connect_by_path(sign(bitand(&num,power(2,level-1))),','),','))) from dual
connect by power(2,level-1)<=&num
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
1 comment:
Hmm it looks like your website ate my first comment (it was super long)
so I guess I'll just sum it up what I submitted and say, I'm thoroughly enjoying
your blog. I too am an aspiring blog writer but I'm still new to everything. Do you have any tips for beginner blog writers? I'd
genuinely appreciate it.
Look at my webpage ... Sac A Main Louis Vuitton
Post a Comment