AS
AS
AS buyrug‘i taxallusli ustun yoki jadval nomini o‘zgartirish uchun ishlatiladi.
Taxallus faqat so‘rovning davomiyligi uchun mavjud.
Ustunlar uchun alias
Quyidagi SQL kodi ikkita alias yaratadi: biri CustomerID ustuni uchun va ikkinchisi CustomerName ustuni uchun:
Quyidagi SQL iborasi ikkita taxallus yaratadi. E’tibor bering, agar taxallus nomida bo‘shliqlar bo‘lsa, u qo‘sh tirnoq yoki kvadrat qavsni talab qiladi:
Misol
SELECT CustomerName AS Customer, ContactName AS [Contact Person]
FROM Customers;
O‘zingiz sinab ko‘ring »
quyidagi SQL operatori (so‘rovi) to‘rtta ustunni (manzil, pochta indeksi, shahar va mamlakat) birlashtirgan "Manzil" nomli taxallusni yaratadi:
Misol
SELECT CustomerName, Address + ', ' + PostalCode + ' ' + City + ', ' + Country
AS Address
FROM Customers;
O‘zingiz sinab ko‘ring »
Eslatma: Yuqoridagi SQL buyrug‘i MySQL’da ishlashi uchun quyidagidan foydalaning:
SELECT CustomerName, CONCAT(Address,', ',PostalCode,', ',City,', ',Country) AS Address
FROM Customers;Jadvallar uchun alias
Quyidagi SQL operatori (so‘rovi) CustomerID=4 (Around the Horn) bo‘lgan mijozning barcha buyurtmalarini tanlaydi. Biz "Customers" va "Orders" jadvallaridan foydalanamiz va ularga mos ravishda "c" va "o" taxalluslarini beramiz (bu yerda SQLni qisqartirish uchun taxalluslardan foydalanamiz):
Misol
SELECT o.OrderID, o.OrderDate, c.CustomerName
FROM Customers AS c, Orders AS o
WHERE c.CustomerName="Around the Horn" AND c.CustomerID=o.CustomerID;
O‘zingiz sinab ko‘ring »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!