Skip to content

Instantly share code, notes, and snippets.

@dodangquan

dodangquan/Tìm sinh viên chưa đăng ký tín chỉ.sql

Created August 9, 2015 06:40
Show Gist options
  • Save dodangquan/550a50897d163a678ac3 to your computer and use it in GitHub Desktop.
Save dodangquan/550a50897d163a678ac3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Tìm sinh viên chưa đăng ký tín chỉ.sql
SELECT * FROM [Sinh Vien]
WHERE [Ma Sinh Vien] NOT IN (
SELECT DISTINCT [Ma Sinh Vien] FROM [Bang Dang Ky]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment