Purchase Solution

SQL Operator Definitions

Not what you're looking for?

Ask Custom Question

SQL is a language used to access and manipulate data that is stored in a database. Most DBMS use SQL to communicate with the underlying database. The DBMS interface allows for SQL commands to be used without the user having to actually know or even see these commands. However, it is important for database administrators and analysts to understand SQL since direct use of the language may be needed on occasion, such as troubleshooting.

Compose a short definition and provide one example for each of the following SQL operators: SELECT, INSERT INTO, UPDATE, and DELETE. (700 WORDS).

Purchase this Solution
Solution Summary

The answer to this problem explains common SQL Operators. The references related to the answer are also included.

Solution Preview

The select statement is used to 'select' or choose data from a database. The result of the select operator is stored in a result table called the result set(1). The common SQL syntax for select is :
SELECT column name or names
FROM table name.

Example of the SELECT operator in SQL is
A 'Company' table:
C_Id Name City Address
1 MSCOLA Los Angeles Pheasant Ave 10
2. JOHNSON Los Angeles Cross Road 20
3. DOWEL NYC White Ave 24

The example of the operation of the SELECT statement is:
SELECT Name, Address FROM Company
The result will look like this:
Name Address
MSCOLA Pheasant Ave 10
JOHNSON Cross Road 20
DOWEL White Ave 24

The SQL select operator is used to retrieve data from a table in a database. The query may get information from either all the columns in a table or specified columns in a table. To make an SQL Select statement, it is necessary to specify the column name and the table name. SELECT in SQL is the most commonly used Data Manipulation Language operator. 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 ...

Solution provided by:
Hatim Baxamusa, MBA
Education
  • BSc , University of Calcutta
  • MBA, Eastern Institute for Integrated Learning in Management
Recent Feedback
  • "I read your comments, and thank you for this feedback. Do I need to find other studies that applied this methodology Ive used? That's where I'm stuck at."
  • "Thank you kindly sir. "
  • "Excellent and well explained. --Thank you kindly. "
  • "Awesome notes. I appreciate you."
  • "I have the follow-up project and I will assign that to you very soon. "
Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Introduction to Finance

This quiz test introductory finance topics.

View More Free Quizzes
Related BrainMass Solutions

  • data manipulation capabilities

    The PIVOT operator is very similar to the TRANSFORM operator that Microsoft Access provides. It is used to rotate rows into columns. The best way to learn about PIVOT is through an example (see Figure 1).

  • Union and Union All Operations in SQL

    In SQL the UNION operator combines the results of two SQL queries into a single table of all matching rows. The two queries must have matching fields and data types in order to join them. Any duplicate records are automatically removed.

  • Question about SQL Commands

    23718 Question about SQL Commands See attach file for charts and data. Use SQL, and the Premiere Products database (see Figure 1.2) to complete the following exercises. 1.

  • SQL pattern matching with MS Access

    132318 SQL pattern matching with MS Access Why wont this query give me any results?

  • Invertibility proof

    Please use only elementary theorems about linear operators, transformations, and definitions of invertibility. Please see the attachment. Let be a linear operator on a finite dimensional vector space V. Assume , where U is a linear operator.

  • Using OR, AND, ANY, and ALL with SQL queries

    Likewise, the following query uses the OR operator: SELECT * FROM mytable WHERE state = 'active' OR state = 'removed'; This will select all records from the table where the state is either 'active' or 'removed'.

  • Subquery and Join

    As we may know, an outer join uses the plus sign (+) operator to tell the database to return all non-matching rows with NULL values.

  • Algorithm to generate an increasing sequence of integers

    . */ SET @INTEGER += 1; END A SQL algorithm to generate the increasing sequence of positive integers whose only prime divisors are 2 and 3. The version will run in SQL 2008 or any edition that supports the += operator.

  • features and uses of SQL

    select loan-number from loan where amount is null Since a predicate in a where clause can involve Boolean operations such as and, or and not on the results of comparisions, the definitions of the Boolean operations are extended to deal with the

View More Related Solutions