This week's giveaway is in the Spring forum.
We're giving away four copies of Microservices Testing (Live Project) and have Chris Love & Andres Sacco on-line!
See this thread for details.
Win a copy of Microservices Testing (Live Project) this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

HFEJB EJB-QL Between expression Pg 416

 
Ranch Hand
Posts: 85
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
First of all Great Book Kathy and Bert!!
I have never read a book that fast and in just 1.5 week i am at page 416..
Question:It is written that BETWEEN is Inclusive and NOT BETWEEN is Exclusive. doesnt it mean that the movies not in the year 75 and 76 should then be WHERE m.year NOT BETWEEN 1974 AND 1977 as the it will be EXCLUSIVE and consider year 75 and 76.
Thanks in Advance.
Nileesha
 
Ranch Hand
Posts: 1392
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Question:It is written that BETWEEN is Inclusive and NOT BETWEEN is Exclusive. doesnt it mean that the movies not in the year 75 and 76 should then be WHERE m.year NOT BETWEEN 1974 AND 1977 as the it will be EXCLUSIVE and consider year 75 and 76.


For m.year NOT BETWEEN 1974 AND 1977 means 1974, 1975, 1976 and 1977 are excluded.
Joyce
 
Nileesha Bojjawar
Ranch Hand
Posts: 85
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Joyce ,
Thanks for the reply.
I thought that the exclusinve implies excluding the values in the range specified for the between clause.

Thanks
 
Space seems cool in the movies, but once you get out there, it is super boring. Now for a fascinating tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic