SQL OD ZERA - #1 SELECT, FROM, AS

KURS SQL - PRZYGOTOWANIA

KURS SQL - ZAPYTANIA

SELECT & FROM

SELECT *
FROM customers
                        

SELECT *
FROM employees
                        

SELECT
  EmployeeId, LastName,
  FirstName, Title,
  ReportsTo, BirthDate,
  HireDate, Address
FROM employees
                        

SELECT
  EmployeeId, LastName,
  FirstName, Title,
  ReportsTo, HireDate,
  Address, BirthDate
FROM employees
                        

SELECT
  EmployeeId, LastName,
  FirstName, Title
FROM employees
                        

SELECT
  EmployeeId, LastName,
  Title, FirstName
FROM employees
                        

SELECT
  EmployeeId, FirstName,
  LastName, Title
FROM employees
                        

SELECT
  EmployeeId, FirstName,
  LastName, Title
FROM employees
                        

AS (ALIAS)

SELECT
  EmployeeId AS NumerPracownika,
  FirstName AS PierwszeImie,
  LastName AS Nazwisko,
  Title AS Tytul
FROM employees
                        

SELECT
  EmployeeId AS [Numer Pracownika],
  FirstName AS [Pierwsze Imie],
  LastName AS [Nazwisko],
  Title AS [Tytul]
FROM employees
                        

SELECT
  EmployeeId `Numer Pracownika`,
  FirstName `Pierwsze Imie`,
  LastName `Nazwisko`,
  Title `Tytul`
FROM employees