Need Help: how to get data of previous row from a specified row

Thu, 28 Mar 2013 07:21:18 GMT

Hi,

I have requirement where, i have a set of values in a table as shown below

Table1

I want to display the data as below, that is the data from table1 should be derived to table2 as shown below
Where the rating system is that when even a company is given a rating symbol of 'Z' than that is rating is called a Default rating and
I need to get the rating before the company that has been defaulted that rating before the 'Z' rating

Table2

Company	Rating before default	Date of Rating before default	Date of Default regconition
Comp1	YY	01-feb-2011	01-mar-2011
Comp2	XXX	02-feb-2011	03-sep-2011
Comp3	YY	01-apr-2011	04-jun-2011
Comp3	X	01-oct-2011	01-dec-2011

Thanks in advance

Re: Need Help: how to get data of previous row from a specified row

kaushiknsolanki — Thu, 28 Mar 2013 07:30:15 GMT

Hi,

Gysbert has already sent you the solusion for this.

in this post.

isnt is this helpful.

Regards,

Kaushik Solanki