select employee.name AS name from employee
The output is TOM but I need 'TOM' with the two single quotes. I have tried
to add the three single quotation here but it didn't work out.
B*****g 发帖数: 34098
2
3个不行试4个
select ''''||employee.name||'''' AS name from employee
tried
【在 y***a 的大作中提到】 : select employee.name AS name from employee : The output is TOM but I need 'TOM' with the two single quotes. I have tried : to add the three single quotation here but it didn't work out.
