Re: Declare a table as like MS SQL Server
Posted by:
Ra Nala
Date: January 04, 2018 11:49AM
Hi Peter Sir,
Could you please help on this i am not able to get below logic in MySQL database. in the bellow data, i have only data for 5 th and 8th rows i.e. F,5,227 and F,8,121.
that 227 data should repeat for previous record AND 121 data should repeat for previous records.
Before logic
RPRT_ID SER MODEL
F 1 null
F 2 null
F 3 null
F 4 null
F 5 227
F 6 null
F 7 null
F 8 121
After logic:
RPRT_ID SER MODEL
F 1 227
F 2 227
F 3 227
F 4 227
F 5 227
F 6 121
F 7 121
F 8 121
Kindly help me
Thank you
Subject
Views
Written By
Posted
1056
January 03, 2018 11:35AM
684
January 03, 2018 12:09PM
645
January 03, 2018 01:02PM
543
January 03, 2018 04:02PM
Re: Declare a table as like MS SQL Server
950
January 04, 2018 11:49AM
732
January 04, 2018 12:35PM
656
January 04, 2018 01:03PM
813
January 04, 2018 05:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.