Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Alla aktiers värde baserat på de 200 senaste dagarna
- SELECT s_code, AVG(s_latest) FROM s_value WHERE DATE(tdstamp) < DATE(NOW() - INTERVAL 200 DAY) GROUP BY s_code LIMIT 200
- # En specifik akties värde under 200 dagar
- SELECT s_code, AVG(s_latest) FROM s_value WHERE s_code = 'NYF' AND DATE(tdstamp) < DATE(NOW() - INTERVAL 200 DAY)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement