diff options
Diffstat (limited to 'src/database/sql/fetch_display_submissions.sql')
| -rw-r--r-- | src/database/sql/fetch_display_submissions.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/src/database/sql/fetch_display_submissions.sql b/src/database/sql/fetch_display_submissions.sql new file mode 100644 index 0000000..5e836b3 --- /dev/null +++ b/src/database/sql/fetch_display_submissions.sql @@ -0,0 +1,10 @@ +SELECT +submission.id AS id, +user.username AS username, +submission.language AS language, +submission.details AS details, +submission.code AS code +FROM submission JOIN user +ON user.id = submission.user_id +WHERE submission.problem_id = ?1 +ORDER BY length(submission.code); |