Advanced SQL
Top number of records
SELECT column_name FROM table_name LIMIT 5;
Like/Not Like
SELECT * FROM Customers WHERE Country NOT LIKE '%land%';
In
SELECT column_name FROM table_name WHERE column_name IN ('value1', 'value2',...);
Between.. And..
SELECT column_name FROM table_name WHERE column_name BETWEEN 'value1' AND 'value2';
Inner Join
SELECT column_name FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name;
or
SELECT column_name FROM table1 JOIN table2 ON table1.column_name=table2.column_name;
Left Join
SELECT column_name FROM table1 LEFT JOIN table2 ON table1.column_name=table2.column_name;
or
SELECT column_name FROM table1 LEFT OUTER JOIN table2 ON table1.column_name=table2.column_name;
Right Join
SELECT column_name FROM table1 RIGHT JOIN table2 ON table1.column_name=table2.column_name;
or
SELECT column_name FROM table1 RIGHT OUTER JOIN table2 ON table1.column_name=table2.column_name;
Full Outer Join
SELECT column_name FROM table1 FULL OUTER JOIN table2 ON table1.column_name=table2.column_name;