PostgreSQL LEFT: Get First N Characters in a String

PHOTO EMBED

Wed Jul 26 2023 03:42:07 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

SELECT LEFT(first_name, 1) initial,
    COUNT(*)
FROM customer
GROUP BY initial
ORDER BY initial;
content_copyCOPY

https://www.postgresqltutorial.com/postgresql-string-functions/postgresql-left/