× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
5
k
4
c
4
M
3
t
3
i
3
B
3
k
3
m
3
c
3
o
3
l
3
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
plily1 plily1
wrote...
Go to Answer
Posts: 637
Rep: 0 0
6 years ago
Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer1013?
 a. SELECT customer FROM customers WHERE customer =(SELECT state FROM customers WHERE state = 'NJ');
  b. SELECT customer FROM customers WHERE state =(SELECT state FROM customers WHERE customer=1013);
  c. SELECT customer FROM customers WHERE customer IN(SELECT state FROM customers WHERE state = 'NJ');
  d. SELECT customer FROM customers WHERE state EXISTS(SELECT state FROM customers WHERE customer=1013);
Read 58 times
2 Replies
Replies
Answer verified by a subject expert
npalmierinpalmieri
wrote...
#1
Top Poster
Posts: 886
Rep: 4 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

plily1 Author
wrote...
#2
6 years ago
Thank you for answering correctly!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  960 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 146
  
 376
  
 90
Your Opinion
What's your favorite math subject?
Votes: 315
Previous poll results: Which of the following is the best resource to supplement your studies: