SQL Select Top

Essential Question: How can I create a query that limits the number of results?

Mastery Objectives:

• SWBAT create queries that limit the number of results.

• SWBAT identify 7 ways that they can create a query that limit the number of results.

Directions: There are 7 ways to limit the results from a query. You may want to limit results in very large databases. Only complete the items in bold. Here are examples of 7 different ways to limit the results from a query:

Here is the SQL Editor. https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_top&ss=-1 Please create the queries below, screenshot them into a google doc and write a description for the results. 

SELECT TOP 3 * FROM Customers;

• Create a query that selects 10 from Customers using the method above;

• Create a query that selects 5 from Customers using the method above;

• Create a query that selects 40 from Products using the method above;

SELECT TOP 50 PERCENT * FROM Customers;

• Create a query that selects 30 percent using the method above;

• Create a query that selects 75 percent using the method above;

• Create a query that selects 20 from Products using the method above;

SELECT TOP 3 * FROM Customers WHERE Country='Germany';

• Create a query that selects the top 7 for customers from Brazil using the method above;

• Create a query that selects the top 5 for customers from USA using the method above;

• Create a query that selects the top 10 from customers using the method above from any country;