Advertisement
Guest User

Untitled

a guest
Apr 5th, 2020
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.29 KB | None | 0 0
  1. SELECT track1.TrackId, track1.name, track1.bytes,
  2.     (SELECT
  3.         SUM(track2.bytes)/1000000
  4.      FROM
  5.         tracks track2
  6.      WHERE
  7.         track1.TrackId >= track2.TrackId  
  8.      ORDER BY
  9.         track2.TrackId ) AS SUMA_BAJTOW
  10. FROM
  11.     tracks track1
  12. WHERE
  13.     SUMA_BAJTOW <= 1024
  14. ORDER BY
  15.     track1.TrackId
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement