Skip to content

Instantly share code, notes, and snippets.

@max-programming

max-programming/DBMS_P2_Q11.sql

Last active September 19, 2022 15:22
Show Gist options
  • Save max-programming/683dfed0b189059c22599638beffc758 to your computer and use it in GitHub Desktop.
Save max-programming/683dfed0b189059c22599638beffc758 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DBMS_P2_Q11.sql
SELECT
student_id
FROM
studies
WHERE
subject_id NOT IN (101, 103, 105)
SELECT
student_id
FROM
studies
WHERE
subject_id != 101
AND subject_id != 103
AND subject_id != 105
Raw
DBMS_P2_Q9.sql
SELECT
subject_id,
credit
FROM
subject
WHERE
subject_name IN ('Java', 'DBMS', 'WTP')
SELECT
subject_id,
credit
FROM
subject
WHERE
subject_name = 'Java'
OR subject_name = 'DBMS'
OR subject_name = 'WTP'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment