AS


AS

The AS operator changes a column heading in a table during a SELECT command. This is very useful in reports.
El operador AS permite cambiar el nombre del encabezado de una tabla en un comando SELECT. Esto es extremadamente útil en los reportes.

SQL
-- Motorola database
SELECT first_name, last_name
FROM employee

mot_as1

SQL
-- Motorola database
SELECT first_name AS 'First Name', last_name AS 'Last Name'
FROM employee

mot_as2

Problem 1
ford > Write an SQL script to create and populate the ford database using: (a) Microsoft SQL Server, (b) Oracle, (c) MySQL.
Escriba un script de SQL para crear y llenar la base de datos ford usando (a) Microsoft SQL Server, (b) Oracle, (c) MySQL.

© Copyright 2000-2019 Wintempla selo. All Rights Reserved. Sep 05 2019. Home