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
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.

Excel Introductory Quiz

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

Basic Networking Questions

This quiz consists of some basic networking questions.

C# variables and classes

This quiz contains questions about C# classes and variables.

C++ Operators

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

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.

  • 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.

  • 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.

  • 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