Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: Raspberry on May 16, 2016



Title: The following two SQL statements will produce different results: Select last_name, first_name from c
Post by: Raspberry on May 16, 2016
The following two SQL statements will produce different results:

   Select last_name, first_name
      from customer
   where state = 'MA' or state = 'NY' or state = 'NJ' or state = 'NH' or state = 'CT';

   Select last_name, first_name
      from customer
      where state in ('MA','NY','NJ','NH','CT');
A) True
B) False


Title: Re: The following two SQL statements will produce different results: Select last_name, first_name fr
Post by: dorkalot on May 22, 2016
Content hidden


Title: Re: The following two SQL statements will produce different results: Select last_name, first_name from c
Post by: Raspberry on May 30, 2016
And right on time, exam is this Tuesday :(


Title: Re: The following two SQL statements will produce different results: Select last_name, first_name from c
Post by: dorkalot on May 31, 2016
Wonder, thx for the feedback