SELECT *
FROM erkaklar_kiyimi
WHERE Narxi >="200000"
Ayollar kiyimi bazasini yaratish uchun struktura:
INSERT INTO ayollar_kiyimi
(T_r,Nomi,Razmeri,Brendi,Davlati,Narxi)
VALUES
("1","Yupka","XS","GUCCI","CHINA","180000"),(2,"Kofta","S","ZARA","FRANSIYA","200000"),(3,"Palto","M","DIOR","Italiya","1000000"),(4,"Kostyum","XL","D&G","Turkiya","800000"),(5,"Ko'ylak","XL","D&G","Italiya","249000"),(6,"Nimcha","XS","Versace","Koreya","160000")
Natija:
Yangi kiyim qo’shish kodi:
INSERT INTO ayollar_kiyimi
(T_r,Nomi,Razmeri,Brendi,Davlati,Narxi)
VALUES
(7,"Kurtka","S","Polo","AQSH","580000")
Natija:
|
