Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order By
CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where REGION = 'E' Order By CUSTOMER
The above is
a) Not an error
b) Error - the string in single quotes 'NORTH' and 'SOUTH'
c) Error - the string should be in double quotes
d) Error - ORDER BY clause

• d.....order by clause...
• 10 years agoHelpfull: Yes(2) No(0)
• two order by cluase are used so it will produce an error
  
  ans : D
• 9 years agoHelpfull: Yes(0) No(0)
• this should be an error -order by clause because don't use order by clause for dataset one if u r using any set operators
• 4 years agoHelpfull: Yes(0) No(0)