school_cd, name, start_year end_year
01 abc 2000 2002
02 mnx 2000 2003
03 xyz 2000 2001




i need a sql stmt to show: (a row for each range)

01 abc 2000 2001
01 abc 2001 2002

02 mnx 2000 2001
02 mnx 2001 2002
02 mnx 2002 2003

03 xyz 2000 2001



Can any one help me in getting this..