A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
bartleby

Concept explainers

Question
Chapter 4, Problem 7TD
Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT STUDENT_ID FROM STUDENT;

  • The given query is used to display each student ID from “STUDENT” table.

“BETWEEN” operator:

  • The “BETWEEN” operator allows user to specify a range of values in a condition.

Syntax for selecting values from the table using “BETWEEN” is as follows:

SELECT STUDENT_ID, STUDENT_NAME, MARK FROM STUDENT WHERE MARK BETWEEN 70 AND 90;

  • The given query is used to display each student ID, name and mark from “STUDENT” table with mark range of “70” and “90” that means including the value “70” and “90”.

Blurred answer
Students have asked these similar questions
Mark the Category field in the BOOK_PRICING table as not being used. Check to see if the field can still be used.
Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd quarter of 2017 (April to June 2017).

Chapter 4 Solutions

A Guide to SQL

Knowledge Booster
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Np Ms Office 365/Excel 2016 I Ntermed
    Computer Science
    ISBN:9781337508841
    Author:Carey
    Publisher:Cengage
  • A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
    Np Ms Office 365/Excel 2016 I Ntermed
    Computer Science
    ISBN:9781337508841
    Author:Carey
    Publisher:Cengage