Explore BrainMass
Share

MySQL SELECT Statements

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Write SELECT statements for the following questions. Make sure to include the statement execution, including the resulting data.

Display all columns and all rows from the Employees table.
9 rows returned
Display the regionid, regiondescription for all rows in the Regions table.
4 rows returned
Modify query 2 so that the column headings are as follows:
"ID" and "Description"
4 rows returned
Display the customer ID, customer name, and region for all customers.
91 rows returned
Display the customer ID, customer name, and region for all customers.
Name the columns "ID," "Name," and "Region" (respectively), and sort the data by the company name.
91 rows returned

So far from my experience this is what I have come up for as what a Select Statement sort of contains, I could be wrong.

The syntax would be SELECT [column] FROM [table]
So let's say I was selecting a column called "Birthday" from a table named "People" , it would be :
SELECT Birthday
FROM People
with multiple columns, you need to use a comma
EXAMPLE:
SELECT, first_name, Birthday
FROM People

Now I just need to put that knowledge to solve the 5 statements above, can anyone help me with this please ?

© BrainMass Inc. brainmass.com October 17, 2018, 10:09 am ad1c9bdddf
https://brainmass.com/computer-science/sorting/mysql-select-statements-495904

Solution Preview

The syntax for your select statement is correct. If you want to return all the columns and all the rows you can use the syntax:
SELECT * FROM ...

$2.19
Similar Posting

Use the Internet or computer magazines to investigate one of the following DBMSs

Use the Internet or computer magazines to investigate one of the following DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase. Then prepare a report that explains how the DBMS handles tow of the following distributed database functions: deadlock, fragmentation, replication, the data dictionary or log, and distributed queries.

View Full Posting Details