Advertisement
Thauma

Untitled

Jan 25th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.24 KB | None | 0 0
  1. SELECT t.*
  2. FROM  (SELECT Sum(I.end_date - I.start_date) AS czas_realizacji_dni, P.proname
  3.        FROM   implproject1 I, project1 P
  4.        WHERE  P.prono = I.prono
  5.        GROUP  BY p.proname
  6.        ORDER  BY Sum(I.end_date - I.start_date)) t;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement