2-topshiriq Topshirdi: G. Salimov

2-topshiriq Topshirdi: G.Salimov

1. Group by va Order by standart so‘zlaridan foydalanib so‘rov yaratish. Having standart so‘zi orqali so‘rovlar yaratish. 5. Agregat funksiyalardan foydalanish.

Izoh yozilishi kerak!!!

Izoh yozilishi kerak!!!


Izoh yozilishi kerak!!!


Izoh yozilishi kerak!!!

2. Union, Intersect va Minus standart so‘zidan foydalanish.

Izoh yozilishi kerak!!!


Izoh yozilishi kerak!!!

3. Bir nechta jadvallar birlashtirish, «Join» lar bilan ishlash.( Murakkab so‘rovlar yaratish)

Here are the different types of the JOINs in SQL:

• 
  (INNER) JOIN: Returns records that have matching values in both tables
  
• 
  LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table
  
• 
  RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table
  
• 
  FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table
  

Izoh yozilishi kerak!!!
Namunalar keltiramiz!!!

4. Standart funksiyalardan foydalanib so‘rovlar yaratish.

Izoh yozilishi kerak!!!

Izoh yozilishi kerak!!!