Create a new column of value based on another column in Oracle Sql

0

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.

cLICK HERE FOR TABLE

I’d like to create two new columns (see below) – Origin and Dest to show the origin and destination place for each ID.

CLICK HERE FOR TABLE

Really appreciate your help.

Link: Create a new column of value based on another column in Oracle Sql
Source: Stack Sql

Share.

About Author

Leave A Reply