Explore BrainMass
Share

Explore BrainMass

    SQL Statement

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

    a. You have been asked to write a SQL statement that will delete ConsumerID 45678.
    b. Save your SQL query as SQLQuery1D1 and execute the statement.
    c. Create an SQL statement that will delete all records that are from the state of California or Texas.
    d. Save your SQL query as SQLQuery1D2 and execute the statement.
    e. Make a note of many records that were deleted.
    f. Write 1 SQL query that will prove that no records exist for ConsumerID 45678 or the Consumer is from California or Texas.
    g. Save your SQL query as SQLQuery1D3 and execute the statement.
    h. Take a screen shot of your query results.

    © BrainMass Inc. brainmass.com October 10, 2019, 5:35 am ad1c9bdddf
    https://brainmass.com/computer-science/sql/sql-statement-510397

    Attachments

    Solution Summary

    This solution consists of questions on SQL queries mainly DML statements and select statement.

    $2.19