365 Days of Daily Coding: Day 139

Although I said that I wanted to continue working on my Tableau viz, I decided to instead focus on Alteryx. The problem I faced was that the installer is only compatible with Windows and I have to get a virtual machine with windows operating system to work on it. Now, I downloaded a vm software called “VMware” but it is only compatible with mac iOS 12. My mac at that point was mac iOS 11. I had to upgrade my iOS. When i tried to upgrade, unfortunately I did not have storage.

So I purchased icloud that costs me RM 4 every month but alas! I found out that unlike what I thought, the icloud acts a backup storage and anything that you save in icloud is also saved in mac. WTH? So I cleaned my mac and I am now upgrading my iOS. I may have to clean my memory and move some files to google drive. At this point, I dont see any point in continuing my iCloud subscription. Not really keen to have a backup unless it saves storage in my laptop significantly.

Puzzle #24: Page Views

I tried the solution in the live oracle environment here.

WITH temp AS 
(SELECT 1 AS Rws, 23 AS Score FROM DUAL UNION ALL
SELECT 2 AS Rws, 32 AS Score FROM DUAL UNION ALL
SELECT 3 AS Rws, 35 AS Score FROM DUAL UNION ALL
SELECT 4 AS Rws, 37 AS Score FROM DUAL UNION ALL
SELECT 5 AS Rws, 67 AS Score FROM DUAL UNION ALL
SELECT 6 AS Rws, 89 AS Score FROM DUAL UNION ALL
SELECT 7 AS Rws, 90 AS Score FROM DUAL UNION ALL
SELECT 8 AS Rws, 90 AS Score FROM DUAL UNION ALL
SELECT 9 AS Rws, 90 AS Score FROM DUAL UNION ALL
SELECT 10 AS Rws, 90 AS Score FROM DUAL UNION ALL
SELECT 11 AS Rws, 23 AS Score FROM DUAL UNION ALL
SELECT 12 AS Rws, 32 AS Score FROM DUAL UNION ALL
SELECT 13 AS Rws, 35 AS Score FROM DUAL UNION ALL
SELECT 14 AS Rws, 37 AS Score FROM DUAL UNION ALL
SELECT 15 AS Rws, 67 AS Score FROM DUAL UNION ALL
SELECT 16 AS Rws, 89 AS Score FROM DUAL UNION ALL
SELECT 17 AS Rws, 90 AS Score FROM DUAL UNION ALL
SELECT 18 AS Rws, 90 AS Score FROM DUAL UNION ALL
SELECT 19 AS Rws, 90 AS Score FROM DUAL UNION ALL
SELECT 20 AS Rws, 90 AS Score FROM DUAL)

--Using BETWEEN
Select Rws, Score FROM temp
WHERE Rws BETWEEN 10 AND 20;


--Using OFFSET AND FETCH
Select Rws, Score FROM temp
ORDER BY Rws
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;