SELECT studentname, address + ', ' + pincode + ' ' + city + ', ' + country AS Address FROM students
The above query takes the columns address, pincode, city and country, concatenates them by using the + operator with a comma (,) and space ( ) in between each and returns the full address as Address.
Generate
More than just a code generator. A tool that helps you with a wide range of tasks. All in one place.
Function from Description
Text Description to SQL Command
Translate Languages
Generate HTML from Description
Code to Explanation
Fix invalid Code
Get Test for Code
Class from Description
Regex from Description
Regex to Explanation
Git Command from Description
Linux Command
Function from Docstring
Add typing to code
Get Language from Code
Time complexity
CSS from Description
Meta Tags from Description
− sponsored −
