Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT [In], F2, [Out], F5, SUM(Hours) from Table1
  2. WHERE (F2 = (SELECT TOP 1 FROM Table1 ORDER BY ASC)
  3. AND F5 = (SELECT TOP 1 FROM Table1 ORDER BY DESC))
  4. GROUP BY IN, OUT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement