Explore BrainMass
Share

Database Systems SQL Statement Examples

This content was STOLEN 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 16, 2018, 12:19 pm 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