7.字符串拼接

Query:

SELECT fname || " " || lname AS full_name
    FROM tutorial

结果:

{
  "results": [
    {
      "full_name": "Dave Smith"
    },
    {
      "full_name": "Earl Johnson"
    },
    {
      "full_name": "Fred Jackson"
    },
    {
      "full_name": "Harry Jackson"
    },
    {
      "full_name": "Ian Taylor"
    },
    {
      "full_name": "Jane Edwards"
    }
  ]
}

Last updated

Was this helpful?