Sql Programming Tutorials, Guides & Best Practices

Use LIMIT to restrict the number of rows returned by a query, especially for large datasets.

SELECT first_name, last_name FROM users LIMIT 10;

SELECT columns
FROM table1
CROSS JOIN table2;

Using the same tables, to generate a combination of all employees and all departments: