Lag Function Purpose: This function returns result set starting from the previous row in the table. Syntax: Lag(expression [,offset [,default] ] ) over( [ Partition_By_clause] order by clause) Where, Expression => A table column or built-in fun...

Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row, or maybe even worse you are doing multiple self joins. This is where you will start smiling, let’s have a look at an example. I’ll start by ...

1...

i-catching solutions...