LIMIT keyword in SQL

We can set a limit to the returned data. We will use LIMIT keyword to achieve this. See:

SELECT Country

From customers

LIMIT 5;

We can use more than one column with the LIMIT keyword. See below.

SELECT Country, Address, City

From customers

LIMIT 5;

Try it on here:

http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all