× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
j
4
m
4
4
4
n
3
m
3
R
3
V
3
e
3
w
3
j
3
a
3
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
jay123 jay123
wrote...
Go to Answer
Posts: 700
Rep: 0 0
6 years ago
Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least 42.00?
 a. SELECT FROM booksWHERE pubid = 1 OR pubid = 2 OR retail >= 42;
  b. SELECT FROM booksWHERE pubid IN (1, 2) OR retail => 42;
  c. SELECT FROM booksWHERE pubid = 1 AND pubid=2 OR retail >=42;
  d. both a and b
Read 44 times
1 Reply
Replies
Answer verified by a subject expert
Alphabet!Alphabet!
wrote...
#1
Top Poster
Posts: 920
Rep: 5 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

jay123 Author
wrote...

6 years ago
Good timing, thanks!
Mcb
wrote...

Yesterday
Thanks for your help!!
decibul
wrote...

2 hours ago
This site is awesome
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  986 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 381
  
 716
  
 86
Your Opinion
What's your favorite math subject?
Votes: 315
Previous poll results: Where do you get your textbooks?