In the new SQLQuery_… pane, use the Connect button to connect the query to the AdventureWorks saved connection.

Start Azure Data Studio, and create a new query (you can do this from the File menu or on the welcome page).Similarly, the table might contain a Size field and again it’s not unreasonable to assume that there may be multiple products of the same size or even multiple products with the same combination of size and color. It’s not unreasonable to assume that there may be multiple products of the same color. For example, a table of products might contain a Color field that identifies the color of a given product. Often, multiple rows in a table may contain the same values for a given subset of fields. ORDER BY Name OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY Modify the query as shown here, and run it to retrieve the next page of results. The results start at the 0 position (the beginning of the result set) and include only the next 10 rows, essentially defining the first page of results with 10 rows per page. Run the query and note the effect of the OFFSET and FETCH parameters of the ORDER BY clause.ORDER BY Name OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY Modify the existing query to return product Name and ListPrice values: SELECT Name, ListPrice User interfaces and reports often present large volumes of data as pages, you make them easier to navigate on a screen. Retrieve pages of results with OFFSET and FETCH Note that this time the results contain the 20% most expensive products.SELECT TOP (20) PERCENT WITH TIES Name, ListPrice Modify the query to add the PERCENT parameter as shown here, and re-run it. This time, there are 21 rows in the results, because there are multiple products that share the same price, one of which wasn’t included when ties were ignored by the previous query.SELECT TOP (20) WITH TIES Name, ListPrice Modify the query to add the WITH TIES parameter as shown here, and re-run it. Typically, you include an ORDER BY clause when using the TOP parameter otherwise the query just returns the first specified number of rows in an arbitrary order. Run the query and note that the results contain the first twenty products in descending order of ListPrice.Modify the existing query to return the Name and ListPrice of all products: SELECT TOP (20) Name, ListPrice For example, you might want to find the twenty most expensive products. Sometimes you only want to return a specific number of rows. Note that they are sorted into descending order of ListPrice, and each set of products with the same price is sorted in ascending order of Name. Modify the query as shown below to sort the results into descending order of ListPrice, and then into ascending order of Name. Run the query and note that the results now show the most expensive items first.Modify the query as shown below to sort the results into descending order of ListPrice. By default, the ORDER BY clause applies an ascending sort order to the specified field. Run the query and note that the results are listed in ascending order of ListPrice.Modify the query as shown below to sort the results by ListPrice. This time the products are listed in alphabetical order by Name. Modify the query to add an ORDER BY clause that sorts the results by Name, as shown here: SELECT Name, ListPrice Run the query and note that the results are presented in no particular order.Modify the existing query to return the Name and ListPrice of all products: SELECT Name, ListPrice It’s often useful to sort query results into a particular order. Note: If you’re familiar with the standard AdventureWorks sample database, you may notice that in this lab we are using a simplified version that makes it easier to focus on learning Transact-SQL syntax. For your reference, the following diagram shows the tables in the database (you may need to resize the pane to see them clearly). In this lab, you’ll use the Transact-SQL SELECT statement to query and filter data in the AdventureWorks database.

Azure data studio filter tables