n.ö.(2 grup halinde toplam 4 grup)
1.grup
select * from ogrenci where (adi between 'a%' and 'n%') and date='13.12.2013' and ( time='10:00' or time ='13:00') order by adi asc
2.grup
select * from ogrenci where (adi between 'n%' and 'z%' )and date='20.12.2013' and ( time='10:00'or time ='13:00') order by adi asc
i.ö.(2 grup halide)
1.grup
select * from ogrenci where (adi between 'a%' and 'n%') and date='13.12.2013' and time='17:00'
order by adi asc
2.grup
select * from ogrenci where (adi between 'n%' and 'z%' ) and date='20.12.2013' and time='17:00' order by adi asc
Hiç yorum yok:
Yorum Gönder