• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

HFEJB EJB-QL Between expression Pg 416

 
Nileesha Bojjawar
Ranch Hand
Posts: 85
  • Mark post as helpful
  • send pies
  • 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
 
Joyce Lee
Ranch Hand
Posts: 1392
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic