Hi guys,
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
My question;
Create a new column. In this column I would like to show the ratio of A.Price / B.Price when 3 minutes before(a.price) and current data(B.price) with same coin.
ADA/BTC A.price/B.price
ADX/BTC A.price/B.price
...
...
...
ZRT/BTC A.price/B.price
Thanks.Is it understandable?