Concatenate strings
House number (house_num) and street are in two separate columns in evanston311. Concatenate them together with concat() with a space in between the values.
Bu egzersiz
Exploratory Data Analysis in SQL
kursunun bir parçasıdırEgzersiz talimatları
- Concatenate
house_num, a space' ', andstreetinto a single value using theconcat(). - Use a trim function to remove any spaces from the start of the concatenated value.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Concatenate house_num, a space, and street and trim spaces from the start of the result
SELECT ___ AS address
FROM evanston311;