Sql

Search

sql redshift split into first and last name

SELECT
    user_id,
    SPLIT_PART(employee_name,',',1) as employee_last_name,    
    SPLIT_PART(employee_name,',',2) as employee_first_name,
    employee_name,
FROM table

Syntax: SPLIT_PART(string, delimiter, part)

Comment

PREVIOUS	NEXT

Code Example
Sql :: mod function example
Sql :: power query case when
Sql :: quantity count and group by some article
Sql :: the differnece between to values in sql
Sql :: tsql find the value and count of the item that occurs the most in a column
Sql :: tsql remove duplicate rows
Sql :: datagrip go to line
Sql :: like date sql server not working
Sql :: To access SQL database file
Sql :: ACCEPT nome PROMPT on oracle
Sql :: match end of string regex sql
Sql :: sql select rows between 1000 and 2000
Sql :: dollar format in sql server
Sql :: sql server union if table exist
Sql :: inner joint
Sql :: graphql return x item
Sql :: sqlite
Sql :: mysql unique two columns
Sql :: postgresql createdb
Sql :: Get the User Name and Domain Name from an Email Address
Sql :: remove accented characters in bigquery
Sql :: MAKE TABLE FIT in oracle sql
Sql :: luu ckeditor vao mysql
Csharp :: how to restart a scene in unity
Csharp :: c# read text file to list string
Csharp :: check dotnet version command line
Csharp :: c# open folder in explorer
Csharp :: wpf numeric only textbox
Csharp :: get unix time in seconds C#
Csharp :: linux command line exit with error message

Search

SQL

sql redshift split into first and last name

ADD CONTENT