1***********

select*from gruz where kat_obuch_k in ('03', '07') and data_rogden like ('%66') order by kat_obuch_k,vuz_k



2***********

select*from gruz where gok in ('93', '94') and spec between'000401' and '000409' order by gok, spec



3**********

select*from gruz where kat_obuch_k='05'and gp in ('89', '91') and data_rogden like ('%67') order by gp,vuz_k



4**********

select*from gruz where kat_obuch_k='05 and spec between '0601' and '0620' and pol in ('М') order by spec,vuz_k



5**********

select*from gruz where kat_obuch_k='05'and spec='000401' and pol='Ж' and sem_polog_k='0' order by vuz_k


6***********

select*from gruz where gok in ('93', '95') and data_rogden like ('%64') order by gok,vuz_k


7***********

select*from gruz where kat_obuch_k in ('03', '11') and pol='М' order by kat_obuch_k,vuz_k


8**********

select*from gruz where kat_obuch_k='03' and gp in ('90', '91') order by vuz_k, gp


9*******

select*from gruz where gok='94' and spec in ('000101', '000201', '000401') order by spec,vuz_k


10**********

select*from gruz where kat_obuch_k='05' and pol='М' and fio like 'К%' order by vuz_k


11**********

select*from gruz where kat_obuch_k='05' and data_rogden like ('%65') and spec between '0201' and '0230' order spec,vuz_k


12***********

select*from gruz where kat_obuch_k='05' and pol='Ж' and not (fio like '% %Я %) order by spec


13**********

select*from gruz where kat_obuch_k='05' and gp='90' and not (spec in ('0101', '0301')) order by vuz_k,spec


14****************

select*from gruz where gok in ('95', '96') and not (data_rogden like ('%63')) order by gok,vuz_k



15************

select*from gruz where kat_obuch_k in ('03', '07') and fio like 'М%' order by kat_obuch_k,vuz_k



















Чтобы не видеть здесь видео-рекламу достаточно стать зарегистрированным пользователем.
Чтобы не видеть никакую рекламу на сайте, нужно стать VIP-пользователем.
Это можно сделать совершенно бесплатно. Читайте подробности тут.