SQL Advanced

LIMIT

SELECT column_name(s)
FROM table_name
LIMIT number

biasanya bersamaan digunakan dengan ORDER

SELECT column_name(s)
FROM table_name
ORDER BY column_name(s) DESC
LIMIT 2;

LIKE

SELECT * FROM Persons
WHERE City LIKE '%abc%'

ALIAS

SELECT po.OrderID, p.LastName, p.FirstName
FROM Persons AS p,
Product_Orders AS po
WHERE p.LastName='Hansen' AND p.FirstName='Ola'

without

SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName
FROM Persons,
Product_Orders
WHERE Persons.LastName='Hansen' AND Persons.FirstName='Ola'

 

JOIN

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
INNER JOIN Orders
ON Persons.P_Id=Orders.P_Id
ORDER BY Persons.LastName

 

UNION operator is used to combine the result-set of two or more SELECT statements

SELECT E_Name FROM Employees_Norway
UNION
SELECT E_Name FROM Employees_USA