Advertisement
Guest User

Untitled

a guest
Apr 5th, 2020
144
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 )
  10.      AS SUMA_BAJTOW
  11. FROM
  12.     tracks track1
  13. WHERE
  14.     SUMA_BAJTOW <= 1024
  15. ORDER BY
  16.     track1.TrackId
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement