I am new to SQL, and am asked to create two new columns of value based on another column in Oracle Sql.
Here is how data looks like:Under each ID, there is also an IDseq representing a sub-segment in this ID, each with a Start and End place.
I’d like to create two new columns (see below) – Origin and Dest to show the origin and destination place for each ID.
Really appreciate your help.
Link: Create a new column of value based on another column in Oracle Sql
Source: Stack Sql