Truncating strings
In the previous exercise, you calculated the length of the description column and noticed that the number of characters varied but most of the results were over 75 characters. There will be many times when you need to truncate a text column to a certain length to meet specific criteria for an application. In this exercise, we will practice getting the first 50 characters of the description column.
Bu egzersiz
Functions for Manipulating Data in PostgreSQL
kursunun bir parçasıdırEgzersiz talimatları
- Select the first 50 characters of the
descriptioncolumn with the aliasshort_desc
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
-- Select the first 50 characters of description
___(___, ___) AS ___
FROM
film AS f;