sql

Sorting: the 'order by' key word

• The 'order by' sorts the query results in ascending order by default (alphabetical or numerical)
• you can sort it in descending order by adding 'DESC'
• E.G. order by.........DESC

Inserting records

• •The
• ‘insert into’ statement inserts records in a table
• •If
• you are inserting data into every column, you don’t have to specify the column
• name

Update command

• you can edit the contents of one or more records.
• E.G.
• update tblmember
• set town= "hadleigh"
• where member id= 2

SQL involving related tables