The query is as follows:
select * from my_table where rownum <= n
MINUS
select * from my_table where rownum < n
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:
SELECT b.*
FROM (SELECT ROWNUM rownum1, my_table1.*
FROM my_table my_table1) my_table2
WHERE my_table2.rownum1 = 10
Post a Comment