1.Testdb bazasidagi employees hamda jobs jadvalidagi ma’lumotlarni(first_name, last_name, salary – employees , job_title - jobs) inner join yordamida chop eting.
SELECT e.first_name,e.last_name,
e.salary AS maoshi,jobs.job_title
FROM employees AS e JOIN jobs
ON e.job_id = jobs.job_id
Bunda faqat bir biriga bog’langanlarni oladi.
2.northwind strings jadvalidagi ma’lumotlarni kata registrdagi belgilar bilan chop etuvchi so’rov yarating.bazasidagi.
UPDATE jobs SET job_title = UPPER(job_title) WHERE job_id=8
Bunda biz kiritgan malumotlarni hammasini katta harifda chiqaradi.
Do'stlaringiz bilan baham: |