Purchase Solution

SQL Command

Not what you're looking for?

Ask Custom Question

Find the name of each publisher containing the word "and". (Hint: Be sure that your query selects only those publishers that contain the word "and" and not those that contain the letters "and" in the middle of a word. For example, your querry should select the publisher named "Farrar and Giroux," but should not select the publisher named "Random House.") This process is done by SQL.
I tried this but keep getting Random House in my query.
SELECT PUBLISHER_NAME
FROM PUBLISHER
WHERE PUBLISHER_NAME LIKE '%and%'
;

Any ideas will be very helpful.

Purchase this Solution
Solution Summary

SQL Commands are emphasized.

Solution Preview

<br>Hint: If you are looking for the "conjunction" AND, use the fact that there will be "spaces" before ...

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

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.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

View More Free Quizzes
Related BrainMass Solutions

  • PL/SQL package

    If this option is selected, SQL*Menu uses menu command type 5 to invoke SQL*Plus without a new database login and without loading SQL*Plus into memory. Command type 5 invokes SQL*Plus significantly faster then command type 2 or 3.

  • SQL Command to Add MATH SCOPE to the STUDENT Table

    311681 SQL Command to Add MATH SCOPE to the STUDENT Table 1. Write the SQL command to add MATH SCOPE to the STUDENT table. 2. Write the SQL command to add SUBJECT to TUTOR.

  • SQL Query: Student Information

    Query6 Write a SQL statement to display the First and Last Name of students who have the major of Biology or Math. Use the SQL command IN.

  • Oracle Sqlplus

    571912 Oracle Sqlplus I need some help in this exercise: Write and execute an SQL query in SQL*Plus A. Table Creation and Management 1. Create a new table using the CREATE TABLE command.

  • SQL Query Statements

    Use the SQL command IN. Query7 Write a SQL statement to display the First and Last Name of students who have the Status greater than 1 and less than 10. Use the SQL command BETWEEN.

  • simple SQL program demonstrating the use of CREATE FUNCTION command in SQL

    115536 Creating a Function Command in SQL I need a simple SQL program demonstrating the use of CREATE FUNCTION command in SQL. A create table can be used to generate a simple record of items such as name, title, age.

  • write a query

    Looking at Figure 5-11, write the SQL command to add a new redo log group with two members that are 250 kilobytes in size and match the distribution of the other two groups.

  • data definition languages

    DROP Command: The final command of the Data Definition Language, DROP, allows us to remove entire database objects from our DBMS." Reference: http://databases.about.com/od/sql/a/sqlfundamentals_2.htm DDL is basically a sublanguage of SQL.

  • features and uses of SQL

    SQL also supports the SAVEPOINT command. The command SAVEPOINT establishes a savepoint named which marks the current point in the processing of a transaction.

  • SQL Command Code

    240688 SQL Command Code CREATE TABLE contacts (Con_id NUMBER(4), Company_name VARCHAR2(30) not null, E_mail VARCHAR2(30), Last_date DATE DEFAULT SYSDATE, Con_cnt NUMBER(3) CHECK (Con_cnt > 0), PRIMARY KEY (Con_id)); 1.

View More Related Solutions