Explore BrainMass
Share

Explore BrainMass

    Database Systems SQL Statement Examples

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

    Write 2 SQL statements a piece (SELECT INSERT, UPDATE,DELETE) based upon database tables of your choice (i.e. customers, orders, vendors etc). In total, there would be 8 SQL statements (2 for each of the commands (SELECT, INSERT, UPDATE, DELETE). Please show the WHERE clause in a few of them to demostrate the filtering of the recordsets.

    © BrainMass Inc. brainmass.com October 10, 2019, 4:48 am ad1c9bdddf
    https://brainmass.com/computer-science/sql/database-systems-sql-statement-examples-477460

    Solution Preview

    Strategic Planning for Database Systems SQL Statements
    Write 2 SQL statements a piece (SELECT INSERT, UPDATE, and DELETE) based upon database tables of your choice (i.e. customers, orders, vendors etc). In total, there would be 8 SQL statements (2 for each of the commands (SELECT, INSERT, UPDATE, and DELETE). Please show me the WHERE clause in a few of them to demonstrate the filtering of the record sets.

    Sample database table used: ...

    Solution Summary

    This solution describes examples of SQL statements (SELECT, INSERT, UPDATE, DELETE). There are 2 examples of each type making it a total of 8 examples. Some examples also demonstrate the WHERE clause.

    $2.19