{"id":6039,"date":"2020-05-20T11:02:45","date_gmt":"2020-05-20T15:02:45","guid":{"rendered":"http:\/\/springframework.guru\/?p=6039"},"modified":"2020-05-20T11:02:45","modified_gmt":"2020-05-20T15:02:45","slug":"sql-using-the-select-statement","status":"publish","type":"post","link":"https:\/\/springframework.guru\/sql-using-the-select-statement\/","title":{"rendered":"SQL, Using The SELECT Statement"},"content":{"rendered":"

In this short tutorial, we’ll learn the basics of using the SQL SELECT<\/strong> command. To follow along, you will need to have MySQL<\/strong> installed on your system, and you will need to install this simple database<\/a>.<\/p>\n

Select All Columns From a Table<\/h2>\n

We use the “*”<\/strong> to select all the columns in a table. Here is an example<\/strong>:<\/p>\n

SELECT * FROM employees;<\/pre>\n
Output:<\/p>\n\n\n\n\n\n\n
emp_no<\/td>\nbirth_date<\/td>\nfirst_name<\/td>\nlast_name<\/td>\ngender<\/td>\nhire_date<\/td>\n<\/tr>\n
10001<\/td>\n1953-09-02<\/td>\nGeorgi<\/td>\nFacello<\/td>\nM<\/td>\n1986-06-26<\/td>\n<\/tr>\n
10002<\/td>\n1964-06-02<\/td>\nBezalel<\/td>\nSimmel<\/td>\nF<\/td>\n1985-11-21<\/td>\n<\/tr>\n
10003<\/td>\n1959-12-03<\/td>\nParto<\/td>\nBamford<\/td>\nM<\/td>\n1986-08-28<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Select Fewer Columns From a Table<\/h2>\n
We can select fewer columns from a table by naming the columns we want to return. Here is an example that only returns the first and last name from the employees’ table:<\/strong><\/p>\n
SELECT first_name, last_name FROM employees;<\/pre>\n
Output:<\/p>\n\n\n\n\n\n\n
first_name<\/td>\nlast_name<\/td>\n<\/tr>\n
Georgi<\/td>\nFacello<\/td>\n<\/tr>\n
Bezalel<\/td>\nSimmel<\/td>\n<\/tr>\n
Parto<\/td>\nBamford<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Count Number of Rows in a Table<\/h2>\n
To count the number of rows in a table, we use the Count function:<\/strong><\/p>\n
SELECT COUNT(*) FROM employees;<\/pre>\n
Output:<\/p>\n\n\n\n\n
Count(*)<\/td>\n<\/tr>\n
300024<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/p>\n
Select and Where Filter<\/h2>\n
We can filter the values that are returned by using the WHERE clause. Here is an example that only returns employees that are males:<\/strong><\/p>\n
SELECT * FROM employees\r\nwhere gender = 'M'<\/pre>\n
Output:<\/p>\n\n\n\n\n\n\n
emp_no<\/td>\nbirth_date<\/td>\nfirst_name<\/td>\nlast_name<\/td>\ngender<\/td>\nhire_date<\/td>\n<\/tr>\n
10001<\/td>\n1953-09-02<\/td>\nGeorgi<\/td>\nFacello<\/td>\nM<\/td>\n1986-06-26<\/td>\n<\/tr>\n
10003<\/td>\n1959-12-03<\/td>\nParto<\/td>\nBamford<\/td>\nM<\/td>\n196-08-28<\/td>\n<\/tr>\n
10004<\/td>\n1954-05-01<\/td>\nChristian<\/td>\nKoblick<\/td>\nM<\/td>\n1986-12-01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/p>\n
Ordering the Results<\/h2>\n
We can order the results base on the column value by using the ORDER BY <\/strong>statement. Here is an example that returns employees Order By last names:<\/strong><\/p>\n
Output:<\/p>\n\n\n\n\n\n\n
first_name<\/td>\nlast_name<\/td>\n<\/tr>\n
Basim<\/td>\nAamodt<\/td>\n<\/tr>\n
Peternela<\/td>\nAamodt<\/td>\n<\/tr>\n
Gretta<\/td>\nAamodt<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
 <\/p>\n
Conclusion<\/h2>\n
In this short tutorial, you learned the basics of using the SQL SELECT<\/strong> statement. To learn more about SQL, please check out the MySQL<\/strong><\/a> course.<\/p>\n","protected":false},"excerpt":{"rendered":"
In this short tutorial, we’ll learn the basics of using the SQL SELECT command. To follow along, you will need to have MySQL installed on your system, and you will need to install this simple database. Select All Columns From a Table We use the “*” to select all the columns in a table. Here […]Continue reading<\/a><\/p>\n","protected":false},"author":111,"featured_media":4653,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[265],"tags":[132,200],"class_list":["post-6039","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-mysql","tag-sql"],"jetpack_publicize_connections":[],"aioseo_notices":[],"modified_by":"jt","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/springframework.guru\/wp-content\/uploads\/2017\/07\/Banner560x292_08Web.jpg","jetpack_shortlink":"https:\/\/wp.me\/p5BZrZ-1zp","_links":{"self":[{"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/posts\/6039"}],"collection":[{"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/users\/111"}],"replies":[{"embeddable":true,"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/comments?post=6039"}],"version-history":[{"count":10,"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/posts\/6039\/revisions"}],"predecessor-version":[{"id":6106,"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/posts\/6039\/revisions\/6106"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/media\/4653"}],"wp:attachment":[{"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/media?parent=6039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/categories?post=6039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/springframework.guru\/wp-json\/wp\/v2\/tags?post=6039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}