select

SELECT jadvaldan kerakli ustunlarni oladi.

SELECT name, age FROM students;          -- ikki ustun
SELECT * FROM students;                  -- hamma ustunlar
SELECT name, price * qty AS total        -- hisoblangan ustun, AS — nom berish
FROM order_items;

Maslahatlar

• Masala so‘ragan ustunlarni o‘sha tartibda chiqaring — * ko‘pincha xato javob beradi.
• Ustun nomi masalada ko‘rsatilgan bo‘lsa, AS bilan aynan shunday nom bering.
• SQL kalit so‘zlari katta-kichik harfga sezgir emas, lekin o‘qish uchun katta harfda yozish odat.