Ma’lumotlar bazasi Mustaqil ish

11.

• 
  11.
  
• 
  4-laboratoriya ishi
  
• 
  Ma’lumotlarni tanlash va ular ustida amallar.
  
• 
  1.
  
• 
  2.
  

5- LABORATORIYA ISHI

• 
  5- LABORATORIYA ISHI
  
• 
  AND, OR, NOT mantiqiy standart so‘zlardan foydalanish
  

6- LABORATORIYA ISHI
Ma’lumotlarni saralash. Where standart so‘zidan foydalanish

1.

• 
  1.
  

7- LABORATORIYA ISHI

• 
  7- LABORATORIYA ISHI
  
• 
  Group by va Order by standart so‘zlaridan foydalanib so‘rov yaratish
  

8- LABORATORIYA ISHI
Having standart so‘zi orqali so‘rovlar yaratish

2.

• 
  2.
  
• 
  9- LABORATORIYA ISHI
  
• 
  UNION, INTERSECT va MINUS standart so‘zlaridan foydalanish
  

2.

• 
  2.
  

3.

• 
  3.
  
• 
  10- LABORATORIYA ISHI
  
• 
  Standart funksiyalardan foydalanib so‘rovlar yaratish
  

2.

• 
  2.
  

3.

• 
  3.
  

11- LABORATORIYA ISHI

• 
  11- LABORATORIYA ISHI
  
• 
  Agrеgat funksiyalardan foydalanish
  

2.

• 
  2.
  

3.

• 
  3.
  

12- LABORATORIYA ISHI

• 
  12- LABORATORIYA ISHI
  
• 
  Bir nеchta jadvallar birlashtirish, JOINlar bilan ishlash
  

2.

• 
  2.
  
• 
  13- LABORATORIYA ISHI
  
• 
  Murakkab so‘rovlar yaratish. TOP, LIMIT yoki ROWNUM
  

2.

• 
  2.
  

http://fayllar.org