tonMachine100
asked on
repeating values oracle analytics -sql
i have the following data (select * from tbl_years):
and want the follwing output:
what sql syntax (analytic functtion) would i need to use to achive this result? thanks
tbl_id tbl_class tbl_teacher
1 Y07 Mr Jones
2 Y07
3 Y07
4 Y09
5 Y09 Mr Smith
6 Y10 Mr Smith
7 Y11
8 Y11 Mr Brown
9 Y11
10 Y11
and want the follwing output:
tbl_id tbl_class tbl_teacher
1 Y07 Mr Jones
2 Y07 Mr Jones
3 Y07 Mr Jones
4 Y09 Mr Smith
5 Y09 Mr Smith
6 Y10 Mr Smith
7 Y11 Mr Brown
8 Y11 Mr Brown
9 Y11 Mr Brown
10 Y11 Mr Brown
what sql syntax (analytic functtion) would i need to use to achive this result? thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great thanks
Open in new window