DEV Community

Cover image for My first SQL Query
Brenda Aluoch
Brenda Aluoch

Posted on

My first SQL Query

This is my first Microsoft server SQL command, I can't believe it! I really longed for this opportunity .I must thank BlackTech Academy for giving me the opportunity to join 'The free SQL cohort2 training'.
How can I forget to thank the 'DEV COMMUNITY ' for giving me a platform to document my projects and learn more !! #Thank your ,THE DEV COMMUNITY.

Database Overview.
The database was AdventureWorks2017 database with several tables . https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure is the link to access the database

1.#SELECT STATEMENT
-Is a built-in function used to select entire table or column in a table.

a. Showing person from Person. Person table with the first name Rob or Roberto
I applied the following select query command to get Person from person. Person table with the firstname as Rob or Roberto

Image description

b. showing the first 10 records from [Sales].[SalesOrderDetal]

Image description

Top comments (0)