mysql - Get previous record column value in SQL -

mysql - Get previous record column value in SQL -

i have table has 3 columns: date,name,salary

i want query table , add together in result set calculated column can have 2 values: 'new' , 'same'.

the rule assign value is: order records date ascending. if name of current record different name of previous record new column value 'start' else (if same) 'same'.

how can that? there function (something prevrow())? or have create "trick"?

how can in mysql , db2?

it seem db2 (versions after 9.7 @ least) back upwards lag() window function, query should work (although haven't been able test it):

select date, name, salary case when lag(name, 1) on (order date asc) = name 'same' else 'start' end calc_col your_table order date asc

mysql sql db2 record recordset