SQL Server: Select Statement

Level : Beginner
Mentor: Shailendra Chauhan
Type : GuidedLab
Points : 10
Duration : 00:15:00

Lab Details


The SELECT statement in SQL Server is used to display all or specific records from the table. This statement allows us to fetch the records based on our needs or retrieve all records of the table.

In this lab, you will learn how to use Select Statement in SQL Server.

Based on this Customer and Supplier Schema, generate the solutions to the respective queries listed below:

  1. List all suppliers in the UK.
  2. List all customers.
  3. List the first name, last name, and city of all customers.

Lab Objective

Upon completion of this lab, you will be able to:

  • Gain Hands-On Experience on SQL Server Select Statement.


  • You should have a conceptual understanding of SQL Commands.
  • You must have SQL Server Installed on your systems.

Self-paced Membership
  • 22+ Video Courses
  • 800+ Hands-On Labs
  • 400+ Quick Notes
  • 55+ Skill Tests
  • 45+ Interview Q&A Courses
  • 10+ Real-world Projects
  • Career Coaching Sessions
  • Email Support
Upto 60% OFF
Know More
Still have some questions? Let's discuss.
Accept cookies & close this