× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
c
6
r
4
c
3
m
3
h
3
1
3
n
3
s
3
d
3
c
3
r
3
e
3
New Topic  
banoshaher banoshaher
wrote...
Posts: 648
Rep: 0 0
6 years ago
Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
 a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE <'1558-QW1';
 b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = 1558-QW1;
 c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = (1558-QW1);
 d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = 1558-QW1;
Read 56 times
1 Reply
Replies
Answer verified by a subject expert
bhodgesbhodges
wrote...
Top Poster
Posts: 1244
Rep: 8 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

banoshaher Author
wrote...

6 years ago
this is exactly what I needed
wrote...

Yesterday
Smart ... Thanks!
wrote...

2 hours ago
This helped my grade so much Perfect
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1218 People Browsing
Related Images
  
 5497
  
 226
  
 307
Your Opinion