Software Testing Material

A site for software testers. We provide free online tutorials on Manual Testing, Automation Testing - Selenium, QTP, LoadRunner, Testing Tools and many more.

  • Blog
  • Tutorials
    • Manual Testing
    • Java
    • Selenium
      • TestNG
      • Maven
      • Jenkins
    • Framework
    • Katalon
    • Agile
    • SQL
    • VBScript
    • API Testing
  • Tools
    • TestLodge
    • FrogLogic GUI Tool
    • CrossBrowserTesting
    • BrowserStack
    • TestCaseLab
    • Kobiton
    • PractiTest
    • Sikuli
    • Postman
  • Interview Q & A
    • Selenium
    • TestNG
    • Test Framework
    • Explain Framework
    • Manual Testing
    • Software QA
    • Agile
    • Testing As A Career
    • General Interview Questions
    • API Testing
    • SOAP
    • JIRA
    • Protractor
  • Free Resources
  • Guest Post
    • Guest Post Guidelines
  • Training

SQL Select Query – SQL TUTORIAL | Software Testing Material

Last Updated on April 5, 2017 by Rajkumar

SQL Select Query:

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

Syntax:

1
SELECT column_name_1, column_name_2, .. column_name_n FROM table_name;

or

1
SELECT * FROM table_name

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

1
SELECT * FROM SCOREBOARD;

SQL Select Query

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

Syntax:

1
SELECT column_name_3 FROM table_name;

Example:

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

1
SELECT Playername FROM 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

SUBSCRIBE TO GET FREE EBOOK AND REGULAR UPDATES ON SOFTWARE TESTING

Filed Under: SQL

data-matched-content-rows-num="2" data-matched-content-columns-num="3"
Previous Article:
SQL WHERE CLAUSE – SQL TUTORIAL | Software Testing Material
Next Article:
SQL Create Table – SQL TUTORIAL | Software Testing Material

About the Author

Rajkumar SM is a founder of SoftwareTestingMaterial. He is a certified Software Test Engineer by profession and blogger & youtuber by choice. He has an extensive experience in the field of Software Testing. He writes here about Software Testing which includes both Manual and Automation Testing. He loves to be with his wife and cute little kid 'Freedom'.

ADVERTISEMENT

Froglogic-Squish-GUI-Tester
CrossBrowserTesting

TUTORIALS

  • Manual Testing Tutorial
  • Selenium Tutorial
  • TestNG Tutorial
  • VBScript Tutorial
  • Agile Methodology
  • SQL Tutorial for Testers
  • INTERVIEW QUESTIONS

  • Framework Interview Questions
  • Real Time Manual Testing
  • 100 Top Selenium Interview Questions
  • 30 Top TestNG Interview Questions
  • Agile Interview Questions
  • 80 SQL Interview Questions
  • TESTING TOOLS

  • Test Lodge
  • FrogLogic Squish
  • Cross Browser Testing
  • BrowserStack
  • Test Case Lab
  • Sikuli
  • © 2019 www.softwaretestingmaterial.com | About us | Privacy Policy | Contact us | Guest Post | Disclaimer | Terms of use | Sitemap