Open links in new tab
  1. 123

    SQL Server Management Studio (SSMS) allows you to run T-SQL queries for retrieving, inserting, updating, and deleting data. Below are practical examples using the AdventureWorks sample database.

    Basic SELECT Queries Retrieve all columns:

    USE AdventureWorks2022;
    SELECT *
    FROM Production.Product
    ORDER BY Name ASC;
    Copied!

    Retrieve specific columns with alias:

    SELECT Name, ProductNumber, ListPrice AS Price
    FROM Production.Product
    WHERE ProductLine = 'R' AND DaysToManufacture < 4
    ORDER BY Name ASC;
    Copied!

    Aggregations and GROUP BY Summarize sales per order:

    SELECT SalesOrderID, SUM(LineTotal) AS SubTotal
    FROM Sales.SalesOrderDetail
    GROUP BY SalesOrderID
    ORDER BY SalesOrderID;
    Copied!

    Filter groups with HAVING:

    SELECT ProductID, AVG(OrderQty) AS AvgQty
    FROM Sales.SalesOrderDetail
    GROUP BY ProductID
    HAVING AVG(OrderQty) > 5;
    Copied!

    JOIN Examples Inner join to combine employee and person data:

    SELECT E.NationalIDNumber, E.JobTitle, P.FirstName, P.LastName
    FROM HumanResources.Employee AS E
    INNER JOIN Person.Person AS P
    ON E.BusinessEntityID = P.BusinessEntityID;
    Copied!
    How to query using SQL Server?

    We will learn how to query using the SQL language. The basis of a query in SQL Server is the SELECT sentence which allows to select the data to be displayed. To start with this, we will use the AdventureWorks database that contains sample tables and views which will allow us to have the same tables and data.

    sqlshack.com
    SQL Server Tips
    https://www.mssqltips.com/sqlservertip/7163/sql-query-examples
    SQL Query Examples - SQL Server Tips
  1. Microsoft Learn
    https://learn.microsoft.com › en-us › sql › t-sql › queries › select-examples...

    SELECT Examples (Transact-SQL) - SQL Server | Microsoft Learn

    Feb 2, 2026 · This article provides examples of using the SELECT statement. The code samples in this article use the AdventureWorks2025 or AdventureWorksDW2025 sample database, which you can …

  2. SQL Server Tips
    https://www.mssqltips.com › sqlservertip › sql-query-examples

    SQL Query Examples - SQL Server Tips

    • The select statement is the most basic and simple SQL to query data. Here is the basic syntax: The following example will query the information from the Person.Person table from the Adventurework2019 database. The following SQL will query all the columns from the table, by using * instead of specifying column names. You could also use the following...
    See more on mssqltips.com
    • Published: Feb 23, 2022
    • LearnSQL.com
      https://learnsql.com › blog › sql-server-practice-exercises

      15 SQL Server Practice Exercises with Solutions

      May 28, 2024 · Explore 15 SQL Server exercises for beginners, each with a solution and explanation to boost your T-SQL querying skills

    • SQL Server Tutorial
      https://www.sqlservertutorial.net

      SQL Server Tutorial

      The SQL Server Tutorial website offers practical tutorials with many hands-on examples to help you learn SQL Server quickly and effectively.

    • W3School
      https://www.w3schools.com › sql › sql_examples.asp

      SQL Examples - W3Schools

      Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, Python, PHP, Bootstrap, Java, XML and more.

    • Github
      https://github.com › microsoft › sql-server-samples

      GitHub - microsoft/sql-server-samples: Azure Data SQL …

      This GitHub repository contains code samples that demonstrate how to use Microsoft's Azure Data products including SQL Server, Azure SQL Database, Azure …

    • People also ask
      Unable to load answer

      Feedback
    • SQL Shack
      https://www.sqlshack.com › sql-queries-in-sql-server-a-b…

      SQL Queries in SQL Server – a beginner’s guide

      Learn how to create SQL queries in SQL Server using the SELECT, WHERE, GROUP BY, JOIN and other clauses. See examples of queries with the AdventureWorks …

    • GeeksForGeeks
      https://www.geeksforgeeks.org › sql › most-common-sql-qu…

      10 Most Common SQL Queries That You Should Know

      Jul 23, 2025 · In this article, we’ll discuss the Top 10 Most Common SQL Commands and Queries that can help you as a developer when you work with databases while …

    • byexamples.dev
      https://byexamples.dev › tsql-by-example

      T-SQL by Example — T-SQL by Example

      T-SQL by Example Welcome to T‑SQL by Example. Each page shows a bite‑sized example with runnable code, output (when helpful), and a few notes & gotchas. Start with Basics, then explore Joins, …

    • TSQL Tutorial
      https://www.tsql.info › sql-server › examples.php

      SQL Server Examples

      This article provides a collection of SQL Server examples that cover a variety of tasks, from basic data retrieval to complex data manipulation. The examples are written in T-SQL, the standard language for …

    • Related searches for Microsoft SQL Server Query Examples

    Content was generated with AI. Learn more