rafi42

***dışarda olan kitapları okuyan öğenci no

Mar 25th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.16 KB | None | 0 0
  1. 'şu an dışarda olan kitapları okuyan öğrenci numaraları'
  2. SELECT ogrno
  3. FROM kitaplar
  4. WHERE ktbno IN (SELECT ktbno FROM kitaplar WHERE knt=TRUE)
  5. GROUP BY ogrno
Advertisement
Add Comment
Please, Sign In to add comment