1 0 .2 8 -m is o l.
Talabalar jadvalidan barcha talab alarning ism larini
olib, natijaning ikkinchi satridan boshlab ikkita satr chiqazing.
mysql> SELECT nam e FROM student L IM IT 1,2;_____________________
M asalan, MB dan olingan talabalar ro‘yxati ko‘pgina satrlardan
iborat ularni alohida sahifalarda tasvirlash uchu n natijani sahifaga
b o ‘lib-bo ‘lib chiqazish lozim. Ushbu hollarda L I M I T konstruksi
yasi foydalanish uchun juda qulay.
M a ’lumotni bir nechta jadvallardan olish
Ikkita jadvalni bog‘Iash
10.29-misol. Andijonda tu g ‘ilgan talab alarn in g ismi, familiyasi
va t a ’lim muassasasi n o m in i chiqazing.
mysql> SELECT student.surname, student.nam e, univercity.univ_nam e
FROM student, univercity
W here student.city— ‘A ndijon’
and student.univ_id=univercity.univ_id;_________________________________
Do'stlaringiz bilan baham: |