SQL Select Query – SQL TUTORIAL | Software Testing Material

SQL Select Query:

SQL Select Query is used to select data from a Database.

Syntax:

or

where * represents all the columns of the table.

Example:

To get all the records from a table. I have a sample table named ‘SCOREBOARD’. Using the Select query, we could get all the records from the table.

Check this post on how to create a table in SQL.

How To Create Table in SQL

SQL Select Query

To get particular column records from a table using SQL Select Query:

Syntax:

Example:

By using the below code, we could fetch just from one particular column say ‘Playername’ from the table ‘SCOREBOARD’

SQL Select Query

In the next tutorial, we will see How To Use Where Clause In SQL

Check out the complete SQL Tutorial by clicking on below link:

SQL Tutorial – Complete

Sharing is caring.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Like This Post?

We have a lot more where that came from?

We only send really good stuff occasionally, promise.

Rajkumar SM

Leave a Comment

Your email address will not be published. Required fields are marked *

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on whatsapp

Recent Posts:

Scroll to Top
API Testing eBook

DOWNLOAD FOR FREE