Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT [In], F2, [Out], F5, SUM(Hours) from Table1
- WHERE (F2 = (SELECT TOP 1 FROM Table1 ORDER BY ASC)
- AND F5 = (SELECT TOP 1 FROM Table1 ORDER BY DESC))
- GROUP BY IN, OUT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement