Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- \BEGIN{TABLE}
- \caption {test4union}
- \BEGIN{tabular}{|l|}
- \hline
- Test query BEFORE \\ \hline
- SELECT DISTINCT personID, groupID, moduleID, taskID, SubmissionTime\\ FROM Submissions WHERE PassedTests IS NOT NULL \\UNION \\SELECT DISTINCT personID, groupID, moduleID, taskID, SubmissionTime\\ FROM Submissions WHERE PassedTests IS NULL; \\ \hline
- Client side timing: 0.1400\\Server side timing: 0.1337 \\ \hline
- Test query after \\ \hline
- SELECT DISTINCT personID, groupID, moduleID, taskID \\ FROM Submissions WHERE PassedTests IS NOT NULL \\UNION ALL\\SELECT DISTINCT personID, groupID, moduleID, taskID \\ FROM Submissions WHERE PassedTests IS NOT NULL; \\ \hline
- Client side timing: 0.0780\\Server side timing: 0.0657 \\ \hline
- \END{tabular}
- \END{TABLE}
Advertisement
Add Comment
Please, Sign In to add comment