Lets do some mathematics!!
We need to calculate factorial of numbers (say from 1 to 10). One of the useful queries can be as follows:
SELECT
rownum,
EXP(SUM(LN(rownum)) OVER (ORDER BY ROWNUM)) Factorial
FROM all_objects
WHERE rownum < 10
(Note : This query was given to me by my friend and mentor Mr. Bucchibabu).
I hope it helps in some way or other!!
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