Source: dzone.com
SQL: Using the SELECT StatementCategory: Database
by To follow along, you will need to have MySQL installed on your system, and you will need to install this simple database.
Here is an example: Output: 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: Output: To count the number of rows in a table, we use the Count function: Output: We can filter the values that are returned by using the WHERE clause. Here is an example that only returns employees that are males: Output: We can order the results base on the column value by using the ORDER BY statement.
Here is an example: Output: 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: Output: To count the number of rows in a table, we use the Count function: Output: We can filter the values that are returned by using the WHERE clause. Here is an example that only returns employees that are males: Output: We can order the results base on the column value by using the ORDER BY statement.
Related Articles
Community Partners
DevOps Careers