• Normally i want to Divide a.price/b.price with this code. Because I want to see the next change in 3 minutes.

    Select a.tarih,a.coin,(A.price),b.tarih,b.coin,(B.price) from (SELECT tarih, coin, MIN(price ) AS price
    FROM dbo.cointahmin
    GROUP BY tarih, coin order by tarih desc,coin OFFSET 300 ROWS
    FETCH NEXT 100 ROWS ONLY) A,
    (SELECT Top 100 tarih, coin, MIN(price ) AS price
    FROM dbo.cointahmin
    GROUP BY tarih, coin order by tarih desc,coin) B