SQL By Example: Learn how to create and query databases in eight easy lessons! by Charlotte McGary

Author:Charlotte McGary [McGary, Charlotte]
Language: eng
Format: epub, azw3, pdf
Published: 2017-05-28T07:00:00+00:00

To use LIKE, you would rewrite the query as follows: (IMPORTANT: the __ in the WHERE statement below is two successive underscore characters.):

SELECT Planet

FROM dbo.Planets

WHERE Planet LIKE '__r%';

For the following example, you'll need to add a column called "Class" to the Planets table. The Class field will be a two character designation. The first character will be either a "G" or an "S", representing Gas and Solid, respectively. The second character will be either an "L" or an "M", representing an axial tilt of less than 90 degrees or more than 90 degrees, respectively.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.