data Manipulation query

• RDBoy

  SSC Enthusiast

  Points: 175

  More actions

  November 24, 2021 at 5:29 am

  #3956345

  Hi All,

  I am new to this forum and trying to develop my TSQL skills. I have the below  script

  create table test (from_set int );

  insert into test values(10)

  insert into test values(20)

  insert into test values(30)

  insert into test values(40)

  insert into test values(50)

  select * from test ;

  go;

  select from_set,

  from_set*10 as new_var

  from test;

  o/p required -

  I don't know how to get "pre_set" column

  Please find required o/p attached as png

  Attachments:

  You must be logged in to view attached files.

• pietlinden

  SSC Guru

  Points: 63505

  More actions

  November 24, 2021 at 6:10 am

  #3956362

  You're looking for LAG().

  SELECT from_set
  ,prevVal =  LAG(from_set,1) OVER (ORDER BY from_set)
  FROM Test;