Examples of basic query in SQL Server

In this chapter you will learn:
Basic examples of sql server
Exercise

Basic example

select * from HumanResources.Department

Output
query 1 output

Exercises

  1. View the all records from HumanResources.Employee table in AdventureWorks database.
  2. Show the person address from the AdventureWorks database.
SUMMARY

In this chapter you have learned how to view all records from any specific table of the database. In the next session you will learn about data types in sql.

 

Share your thought