ch6Word下载.docx

1、WHERE movieYear = 1980 OR movieTitle LIKE %Love%However, above query will also return words that have the substring Love e.g. Lover. Below query will only return movies that have title containing the word Love. Love % Love % Love OR movieTitle = Loved）SELECT name AS Exec_NameFROM MovieExecWHERE netW

2、orth = 10000000;e）SELECT name AS Star_NameFROM movieStarWHERE gender = M OR address LIKE % Malibu %6.1.3SELECT model, speed, hdFROM PCWHERE price 1500 ;MODEL RAM SCREEN- - -2001 2048 20.12005 1024 17.02006 2048 15.42010 2048 15.4 4 record（s） selected.SELECT *FROM PrinterWHERE color ;MODEL CASE TYPE

3、PRICE- - - -3001 TRUE ink-jet 993003 TRUE laser 9993004 TRUE ink-jet 1203006 TRUE ink-jet 1003007 TRUE laser 200 5 record（s） selected.Note: Implementation of Boolean type is optional in SQL standard （feature ID T031）. PostgreSQL has implementation similar to above example. Other DBMS provide equival

4、ent support. E.g. In DB2 the column type can be declare as SMALLINT with CONSTRAINT that the value can be 0 or 1. The result can be returned as Boolean type CHAR using CASE.CREATE TABLE Printer （ model CHAR（4） UNIQUE NOT NULL, color SMALLINT , type VARCHAR（8） , price SMALLINT , CONSTRAINT Printer_IS

5、COLOR CHECK（color IN（0,1） ）; CASE color WHEN 1 THEN TRUE WHEN 0FALSE ELSE ERROR END CASE , type, price FROM Printer WHERE color = 1;f）WHERE speed = 3.2 AND price = 10 ;CLASS COUNTRY- -Tennessee USA 1 record（s） selected.SELECT name AS shipNameFROM ShipsWHERE launched 1918 ;SHIPNAME-HarunaHieiKirishim

6、aKongoRamilliesRenownRepulseResolutionRevengeRoyal OakRoyal Sovereign 11 record（s） selected. SELECT ship AS shipName, battleFROM OutcomesWHERE result = sunkSHIPNAME BATTLE- -Arizona Pearl HarborBismark Denmark StraitFuso Surigao StraitHood Denmark StraitKirishima GuadalcanalScharnhorst North CapeYam

7、ashiro Surigao StraitWHERE name = class ;IowaNorth CarolinaYamato 6 record（s） selected.WHERE name LIKE R% As mentioned in exercise 2.4.3, there are some dangling pointers and to retrieve all ships a UNION of Ships and Outcomes is required.Below query returns 8 rows including ship named Rodney.UNIONS

8、ELECT ship AS shipNameWHERE ship LIKE f） Only using a filter like % % % will incorrectly match name such as a b since % can match any sequence of 0 or more characters._% _% _% 0 record（s） selected. As in （e）, UNION with results from Outcomes.Duke of YorkKing George VPrince of Wales 3 record（s） selected.6.1.5The resulting expression is false when neither of （a=10） or （b=20） is TRUE. a = 10 b = 20 a = 10 OR b = 20 NULL TRUE TR