CREATE VIEW
CREATE VIEW
CREATE VIEW buyrug‘i ko‘rinish (view) yaratadi.
Ko‘rinish - bu SQL operatorining natijalar to‘plamiga asoslangan virtual jadval.
Quyidagi SQL Braziliyadagi barcha mijozlarni tanlaydigan ko‘rinishni yaratadi:
Misol
CREATE VIEW [Brazil
Customers] AS
SELECT
CustomerName, ContactName
FROM Customers
WHERE
Country = "Brazil";
Ko‘rinishdan (view) so‘rov qilish
Yuqoridagi ko‘rinishni quyidagicha so‘rashimiz mumkin:
Misol
SELECT * FROM [Brazil Customers];
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!