Quiz on MySQL select clauses, from clauses, order by clauses, where clauses, group by and having clause. The SELECT statement in MySQL is used to retrieve rows from one or more tables. The general syntax for a SELECT statement is SELECT what_to_select FROM which_table WHERE conditions_to_satisfy. What_to_select indicates what you want to see, which can be a list of columns, or * to indicate “all columns”.  Here are some things you can do with the SELECT command: Specify columns to display: Use the column specification portion of the SELECT command to name the columns you want to display.... Show more

Quiz on MySQL select clauses, from clauses, order by clauses, where clauses, group by and having clause.

The SELECT statement in MySQL is used to retrieve rows from one or more tables.

The general syntax for a SELECT statement is SELECT what_to_select FROM which_table WHERE conditions_to_satisfy. What_to_select indicates what you want to see, which can be a list of columns, or * to indicate “all columns”. 

Here are some things you can do with the SELECT command:
Specify columns to display: Use the column specification portion of the SELECT command to name the columns you want to display. For example, `SELECT column1 AS `first column'' FROM my_table.
Use column aliases: Set column aliases to modify the name used for columns in the output.
Use the WHERE clause: Use the SELECT statement with the WHERE clause to filter records. For example, SELECT column_name(s) FROM table_name WHERE condition.
Use the UNION clause: Combine the results of two or more SELECT/TABLE statements without returning any duplicate rows. 

Here are some other things you can use with the SELECT statement: AS alias_name, FROM table_references, and HAVING clause. 

Show less