The following sample with John Deere tractor's invoice demonstrates the usage of double single quotes:

select 'That''s the right amount on the John Deere tractor''s invoice.'

It will print: That's the right amount on the John Deere tractor's invoice.