how to deal quotes in strings in sql

Handling single quote's in strings.

For example if we want to print string  like Lakshmi's , We can use two single quotes in place of one single quote like below.

select 'lakshmi''s'

Output: lakshmi's