Purchase Solution

SQL Statement

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

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

Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Basic Networking Questions

This quiz consists of some basic networking questions.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • SQL Query: Student Information

    510726 SQL Query: Student Information Query1 Write a SQL statement to display Students' First and Last Name. Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.

  • SQL Query Statements

    521043 SQL Query Statements Query1 Write a SQL statement to display Students' First and Last Name. Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.

  • SQL Commands

    Write a SQL statement to show the SKU ande Description of all items stored in a warehouse managed by 'Smith'. Use a subquery. 6.

  • Oracle9i

    Change the password of the CLASSMATE user back to CLASSPASS using the SQL*Plus worksheet. Save the SQL statement file. SQL> ALTER USER CLASSMATE IDENTIFIED BY CLASSPASS Oracle9i is highlighted for password classmates.

  • SQL Statement for Grades

    228216 SQL Statement for Grades See the attached file. 8.

  • MS SQL SERVER 2003

    Problem 2 In addition create your own SQL query from the database · GROUP statement · UNION statement · JOIN statement · INSERT statement · DELETE/DROP statement select Store.Store_Name, Store.Store_Phone_Number, Customer.Phone_Number from

  • SQL Operator Definitions

    The SELECT operator in SQL has many optional clauses such as where, group by, having, and order by. The SQL insert into statement is used to insert a new row in a table. The direct statement is to add data in specific columns (1).

  • Creating a databse using Microsoft SQL Server

    Using the SQL INSERT statement: Go to the Human Resources department in the Kudler Fine Foods intranet.

  • The Appearance of the Relation Result

    There seems to be an error in the SQL code above. I have never seen the PROJECT statement in SQL, nor can I find it in any of the SQL references online (see end of posting).

View More Related Solutions