new column with values depending upon another column

Asked May 15 '18 at 10:25

Active May 15 '18 at 11:09

Viewed 25 times

I have a column "current stage" which can take values from 2 to 8.Based upon it my new column"possible stages" should have the values as 2 to current stage-1. For example: if "current stage" is 5, possible stages should be 2,3,4 .(in sequence)

if ""current stage" is 6, possible stages should be 2,3,4,5 .(in sequence)

edited May 15 '18 at 11:09

Vao Tsun

47,234
13
100
132

asked May 15 '18 at 10:25

umakant

ah - just noticed - are you sure about 9.1?.. what's your `select version()`?.. – Vao Tsun May 15 '18 at 10:35
btw - who knows where Ican test 9.1?.. sqlfiddle, db-fiddle and rextester don't haveone – Vao Tsun May 15 '18 at 10:52
its 8.2 ..sorry for the confusion – umakant May 15 '18 at 11:03

new column with values depending upon another column

0 Answers0