• Post Reply Bookmark Topic Watch Topic
  • New Topic

EJB QL

 
James Foster
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In SQL, to get all records within a range, we write
SELECT * FROM MYTABLE WHERE salary BETWEEN NVL(low_value, salary) AND NVL(hi_value, salary);
If low_value and hi_value are null, then we get the full range.
How do we do it in EJB QL.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!