Home > database >  SQL query
SQL query

Time:11-26

SQL database in a form,
The Date Value1 Value2
The 2020-11-25, 500, 200
The 200 Null 2020-11-24
The 250 Null 2020-11-23
The 2020-11-22 300 Null
The 2020-11-21, 200, 320
,,,
Check out the:
The Date Value1 Value2
The 2020-11-25, 500, 200
The 2020-11-24, 300, 200
The 2020-11-23, 300, 250
The 2020-11-22, 300, 320
The 2020-11-21, 200, 300
,,,
Description: if a list of fields in this date is null, the query results show to nearest to the date before the null values,

CodePudding user response:

SQL database in a form,
The Date Value1 Value2
The 2020-11-25, 500, 200
The 200 Null 2020-11-24
The 250 Null 2020-11-23
The 2020-11-22 300 Null
The 2020-11-21, 200, 320
,,,
Check out the:
The Date Value1 Value2
The 2020-11-25, 500, 200
The 2020-11-24, 300, 200
The 2020-11-23, 300, 250
The 2020-11-22, 300, 320
The 2020-11-21, 200, 320
,,,
Description: if a list of fields in this date is null, the query results show that as the last day before the date of null values,
Under the correct table data wrong places