How to Select Specific Columns in SQL

In most cases you will want to select specific columns in your table as opposed to displaying all columns. To accomplish this task, you itemize the individual columns you want displayed on the output.

To learn how to select specific columns in a table row in an SQL select statement, follow these steps:

  1. You'll need to setup the MySQL database tables. The instructions for the setup can be found in How to add comments in simple SQL selects. Follow steps 1 through 7 in this topic before proceeding to the next step.
  2. Now you will learn how to select specific columns for each row of a table.
  3. Imagine we are required to select the city name and population from the Cities table. We will need to itemize the columns on the select statement as shown in the following SQL statement:
    Select specific columns example
    You will see in the output the two columns you requested for each row of the Cities table.
Author: Stephen Withrow

Stephen has over 30 years of experience in training, development, and consulting in a variety of technology areas including Python, Java, C, C++, XML, JavaScript, Tomcat, JBoss, Oracle, and DB2. His background includes design and implementation of business solutions on client/server, Web, and enterprise platforms. Stephen has a degree in Computer Science and Physics from Florida State University.

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.