Databases Reporting with SQL Working with Text Concatenating Text

Milind Sharma
Milind Sharma
2,656 Points

Why am i getting extra . at the end the select statement?

select street || ", " || city || ", " || state || ", " || zip || ". " || country AS "address" from addresses;

1 Answer

Steven Parker
Steven Parker
203,989 Points

In the template given in the instructions, there's no comma between the state and the zip (but there is one in this query).