posted 8 years ago
Hi, the book shows a query:
The book says the query created will have a single quote prefix of empName like this:
SELECT e.salary FROM Employee e WHERE e.department.name = 'NS65' AND e.name = ''Roberts' ;
Roberts becomes 'Roberts. And it won't find Robert's record.
However, after I tried a few times with this created query, it can find the Robert's record.