{"id":20273,"date":"2020-07-26T21:44:42","date_gmt":"2020-07-27T04:44:42","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=20273"},"modified":"2023-12-01T03:56:11","modified_gmt":"2023-12-01T11:56:11","slug":"sql-select","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-select\/","title":{"rendered":"How to Use the SQL SELECT Statement"},"content":{"rendered":"\n

Databases<\/a> do not just store information, they make data easily accessible. With a little help from the SELECT statement, you can retrieve any set of values from a database that you need.
<\/p>\n\n\n\n

In this guide, we\u2019re going to discuss what the SQL SELECT statement is and how it works. We\u2019ll go through examples of the SELECT statement in action to help you figure out how to use it on an SQL server.<\/p>\n\n\n\n

What is SQL SELECT?<\/h2>\n\n\n\n

The SELECT statement selects data from a database table. The name gives it away.
<\/p>\n\n\n\n

You can use the SELECT statement to retrieve data from one or more tables. You can select all the rows in a table, or rows that meet a certain condition or set of conditions.
<\/p>\n\n\n\n

SELECT clauses use the following structure:
<\/p>\n\n\n\n

SELECT column1, column2 FROM table;
<\/p>\n\n\n\n

This statement selects the columns \u201ccolumn1\u201d and \u201ccolumn2\u201d from the table \u201ctable\u201d.
<\/p>\n\n\n\n

It is easier to understand SQL with an example. We currently have a table called employees with the following values:
<\/p>\n\n\n\n
id<\/strong><\/td>name<\/strong><\/td>title<\/strong><\/td>hired_date<\/strong><\/td>salary<\/strong><\/td><\/tr>
1<\/td>Thomas Carlton<\/td>Sales Representative<\/td>09-08-2019<\/td>29400<\/td><\/tr>
2<\/td>Lisa Nelson<\/td>Sales Representative<\/td>12-09-2019<\/td>29400<\/td><\/tr>
3<\/td>Victoria Carlisle<\/td>Sales Director<\/td>04-02-2017<\/td>37800<\/td><\/tr><\/tbody><\/table>\n\n\n\n

There are three records in the database. You can learn about how this table was created in our SQL INSERT<\/a> and SQL UPDATE<\/a> tutorials.
<\/p>\n\n\n\n

To view the records inside a database, we need to use a SELECT statement.<\/p>\n\n\n\n

Select Specific Columns<\/h2>\n\n\n\n

We\u2019ve been asked by the executive team to produce a list of all employees and their salaries. They do not need any other information: only the employee names and salaries.
<\/p>\n\n\n\n

We can use a SELECT statement to retrieve this information:
<\/p>\n\n\n\n

SELECT ID, name, title, hired_date, salary\nFROM employees;\n<\/pre><\/div>\n\n\n\n
This query returns a list of all the employee names and their salaries from the employees table. The result set is:
<\/p>\n\n\n\n
Name<\/strong><\/td>Salary<\/strong><\/td><\/tr>
Thomas Carlton<\/td>29400<\/td><\/tr>
Lisa Nelson<\/td>29400<\/td><\/tr>
Victoria Carlisle<\/td>37800<\/td><\/tr><\/tbody><\/table>\n\n\n\n
You can select as many columns as you want from a table.<\/p>\n\n\n\n
Select All Columns<\/h2>\n\n\n\n
We could select all of the columns in our table like this:
<\/p>\n\n\n\n
SELECT ID, name, title, hired_date, salary\nFROM employees;\n<\/pre><\/div>\n\n\n\n
This query is verbose or wordy. If we had more columns to select, it would be even longer. That\u2019s where the * operator comes in handy.
<\/p>\n\n\n\n
The * operator selects all the columns in a table. It is also called the wildcard operator and it means everything.
<\/p>\n\n\n\n
SELECT * FROM employees;
<\/p>\n\n\n\n
This query gives us a full report of all the values in the \u201cemployees\u201d table:
<\/p>\n\n\n\n
id<\/strong><\/td>name<\/strong><\/td>title<\/strong><\/td>hired_date<\/strong><\/td>salary<\/strong><\/td><\/tr>
1<\/td>Thomas Carlton<\/td>Sales Representative<\/td>09-08-2019<\/td>29400<\/td><\/tr>
2<\/td>Lisa Nelson<\/td>Sales Representative<\/td>12-09-2019<\/td>29400<\/td><\/tr>
3<\/td>Victoria Carlisle<\/td>Sales Director<\/td>04-02-2017<\/td>37800<\/td><\/tr><\/tbody><\/table>\n\n\n\n
Select Based on a Condition<\/h2>\n\n\n\n
You can select values from a database that meet a condition or set of conditions by using the WHERE clause.
<\/p>\n\n\n\n
Let\u2019s say that we want to find a list of employees who are sales representatives. We could do this by using a WHERE statement:
<\/p>\n\n\n\n
SELECT * FROM employees\nWHERE title = 'Sales Representative';\n<\/pre><\/div>\n\n\n\n
This query selects all the columns from the employees table. Only records where the value of title is equal to Sales Representative are returned:
<\/p>\n\n\n\n
id<\/strong><\/td>name<\/strong><\/td>title<\/strong><\/td>hired_date<\/strong><\/td>salary<\/strong><\/td><\/tr>
1<\/td>Thomas Carlton<\/td>Sales Representative<\/td>09-08-2019<\/td>29400<\/td><\/tr><\/tbody><\/table>\n\n\n\n
We\u2019ve written a separate tutorial on the WHERE clause that you can read. Read our tutorial on the WHERE clause.<\/a><\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
The SELECT statement selects records from a database table. You can select specific columns from a table by specifying those column names in your query. You can select all columns in a database using the wildcard operator (*).
<\/p>\n\n\n\n
Are you up for a challenge? Write SELECT queries which:
<\/p>\n\n\n\n
  • Retrieve a list of employee names.<\/li>
  • Retrieves a list of employees who have the title Sales Director.<\/li>
  • Retrieve a list of employee titles and salaries.<\/li><\/ul>\n\n\n\n
    You\u2019re now ready to use the SELECT statement like an SQL professional!
    <\/p>\n","protected":false},"excerpt":{"rendered":"Databases do not just store information, they make data easily accessible. With a little help from the SELECT statement, you can retrieve any set of values from a database that you need. In this guide, we\u2019re going to discuss what the SQL SELECT statement is and how it works. We\u2019ll go through examples of the…","protected":false},"author":240,"featured_media":19356,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-20273","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql"},"acf":{"post_sub_title":"","sprint_id":"","query_class":"SQL","school_sft":"","parent_sft":"","school_privacy_policy":"","has_review":null,"is_sponser_post":"","is_guest_post":[]},"yoast_head":"\nSQL SELECT: A Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"The SQL SELECT statement selects records from a table in a database. On Career Karma, learn more about how the SQL SELECT statement works.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/careerkarma.com\/blog\/sql-select\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use the SQL SELECT Statement\" \/>\n<meta property=\"og:description\" content=\"The SQL SELECT statement selects records from a table in a database. On Career Karma, learn more about how the SQL SELECT statement works.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-select\/\" \/>\n<meta property=\"og:site_name\" content=\"Career Karma\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/careerkarmaapp\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-27T04:44:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T11:56:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1020\" \/>\n\t<meta property=\"og:image:height\" content=\"680\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"James Gallagher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@career_karma\" \/>\n<meta name=\"twitter:site\" content=\"@career_karma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James Gallagher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"How to Use the SQL SELECT Statement\",\"datePublished\":\"2020-07-27T04:44:42+00:00\",\"dateModified\":\"2023-12-01T11:56:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/\"},\"wordCount\":619,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-select\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/sql-select\/\",\"name\":\"SQL SELECT: A Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg\",\"datePublished\":\"2020-07-27T04:44:42+00:00\",\"dateModified\":\"2023-12-01T11:56:11+00:00\",\"author\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"The SQL SELECT statement selects records from a table in a database. On Career Karma, learn more about how the SQL SELECT statement works.\",\"breadcrumb\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-select\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg\",\"width\":1020,\"height\":680},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-select\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/careerkarma.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\/\/careerkarma.com\/blog\/sql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Use the SQL SELECT Statement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\",\"url\":\"https:\/\/careerkarma.com\/blog\/\",\"name\":\"Career Karma\",\"description\":\"Latest Coding Bootcamp News & Career Hacks from Industry Insiders\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/careerkarma.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\",\"name\":\"James Gallagher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg\",\"caption\":\"James Gallagher\"},\"description\":\"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.\",\"url\":\"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL SELECT: A Guide | Career Karma","description":"The SQL SELECT statement selects records from a table in a database. On Career Karma, learn more about how the SQL SELECT statement works.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/careerkarma.com\/blog\/sql-select\/","og_locale":"en_US","og_type":"article","og_title":"How to Use the SQL SELECT Statement","og_description":"The SQL SELECT statement selects records from a table in a database. On Career Karma, learn more about how the SQL SELECT statement works.","og_url":"https:\/\/careerkarma.com\/blog\/sql-select\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2020-07-27T04:44:42+00:00","article_modified_time":"2023-12-01T11:56:11+00:00","og_image":[{"width":1020,"height":680,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg","type":"image\/jpeg"}],"author":"James Gallagher","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"James Gallagher","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-select\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-select\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"How to Use the SQL SELECT Statement","datePublished":"2020-07-27T04:44:42+00:00","dateModified":"2023-12-01T11:56:11+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-select\/"},"wordCount":619,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-select\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-select\/","url":"https:\/\/careerkarma.com\/blog\/sql-select\/","name":"SQL SELECT: A Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg","datePublished":"2020-07-27T04:44:42+00:00","dateModified":"2023-12-01T11:56:11+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"The SQL SELECT statement selects records from a table in a database. On Career Karma, learn more about how the SQL SELECT statement works.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-select\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-select\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-select\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-taiuG8CPKAQ-unsplash.jpg","width":1020,"height":680},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-select\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/careerkarma.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/careerkarma.com\/blog\/sql\/"},{"@type":"ListItem","position":3,"name":"How to Use the SQL SELECT Statement"}]},{"@type":"WebSite","@id":"https:\/\/careerkarma.com\/blog\/#website","url":"https:\/\/careerkarma.com\/blog\/","name":"Career Karma","description":"Latest Coding Bootcamp News & Career Hacks from Industry Insiders","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/careerkarma.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94","name":"James Gallagher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","caption":"James Gallagher"},"description":"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.","url":"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20273","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/users\/240"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=20273"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20273\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/19356"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=20273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=20273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=20273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}