Kafedra: " Transportda axborot tizimlari va texnologiyalari " 3-laboratoriya ishi


Download 13.6 Kb.
Sana08.04.2023
Hajmi13.6 Kb.
#1341123
Bog'liq
3-Laboratoriya baza


O’ZBEKISTON RESPUBLIKASI OLIY VA O'RTA MAXSUS TA'LIM VAZIRLIGI
TOSHKENT DAVLAT TRANSPORT UNIVERSITETI
Kafedra: " Transportda axborot tizimlari va texnologiyalari "
3-LABORATORIYA ISHI
Fanning nomi: Ma’lumotlar va bilimlar banki



AT-3 guruh

FISH

SANA

IMZO

Bajardi :

Qadamboyev M.I.

28.03.2023




Qabul qildi:

G’afforov N.Y.







Toshkent - 2023 yil
3-LABORATORIYA ISHI
Mavzu: SQL tili yordamida sodda so‘rovlar yaratish.
Ishdan maqsad: SQL tili yordamida avvaldan yaratilgan jadvalga so‘rovlar yaratish hamda natijalar olish.







s elect op_shifokorlar.full_name,city.city from op_shifokorlar,city where op_shifokorlar.birth_city=city.id_c
s elect full_name,birthday from op_shifokorlar where birthday>'01-01-1976'
s elect op_shifokorlar.full_name,op_ishchilar.directions_op from op_shifokorlar,op_ishchilar where op_shifokorlar.directions_op =op_ishchilar .id_op
select * from op_shifokorlar where full_name like 'Ab%'



select op_shifokorlar.full_name,op_shifokorlar.birthday,city.city,op_ishchilar.directions_op from op_shifokorlar,city,op_ishchilar where op_shifokorlar.birth_city=city.id_c and op_shifokorlar.directions_op =op_ishchilar .id_op

Download 13.6 Kb.

Do'stlaringiz bilan baham:




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling