SQL - Update Warning!

Be careful when updating records. If we omit the WHERE clause, ALL records will be updated: Example UPDATE CustomersSET ContactName='Juan'; Try...

SQL - UPDATE Multiple Records

In an update statement, it is the WHERE clause that determines how many records which will be updated. The WHERE clause: WHERE Country='Mexico' will...

SQL - UPDATE Multiple Columns

To update more than one column, use a comma as seperator. Assume we wish to update the customer "Alfreds Futterkiste" with a new contact person and city. We...

SQL - ORDER BY Several Columns Example 2

The following SQL statement selects all customers from the "Customers" table, sorted ascending by the "Country" and descending by the "CustomerName"...

SQL - ORDER BY Several Columns Example

The following SQL statement selects all customers from the "Customers" table, sorted by the "Country" and the "CustomerName" column: Example SELECT * FROM CustomersORDER BY Country,...

SQL - ORDER BY DESC Example

The following SQL statement selects all customers from the "Customers" table, sorted DESCENDING by the "Country" column: Example SELECT * FROM CustomersORDER BY Country DESC; Try...