Here is required  output

('577', '-1','1','2021-02-14');

('563', '-1','1','2021-02-13')

or please share me any other query which will show  max of last 2 days

here is the query

SELECT Div_ID,

CustomerID,

Div_Status,

LogDate ,

LogDate

FROM ( SELECT Div_ID,

CustomerID,

Div_Status,

LogDate,

LAG(Div_Status,1,0) OVER (PARTITION BY Div_ID ORDER BY logdate) AS PreviousValue,

LEAD (Div_Status,0,1) OVER (PARTITION BY Div_ID ORDER BY logdate) as NextValue

FROM dbo.Table_1

) AS...

can not select top2 logdate along with other columns when really not required

Please do not use top(2) . i can not use in my existing query ..help me with alternatives

Sorry, here is input  data for last 2 max days

INSERT INTO [dbo].[Table_1]

([div_id]

,[customerid]

,[div_status]

,[logdate])

VALUES

('563', '-1','1','2021-02-13'),

('577', '-1','1','2021-02-12'),

('577', '-1','1','2021-02-10');

Suggestion please

sorry  -1 mistakenly came. it is 1 only in the first row

Actually more data loaded.. So instead of 1,01,0 records more 1,1,1 values coming div_status

output is getting more 1,1,1 records 1,0,1,0..Any suggestion...

Hi Expert,




here is the query

Create table statement

CREATE TABLE [dbo].[Table_1](
[div_id] [nchar](10) NULL,
[customerid] [nchar](10) NULL,
[div_status] [nchar](10) NULL,
[logdate] [date] NULL
) ON [PRIMARY]
GO




Insert Data:

INSERT INTO [dbo].[Table_1]
([div_id]
,[customerid]
,[div_status]
,[logdate])
VALUES
('495','-1','-1','2021-02-14'),

('495','-1' ,'1','2021-02-14'),
('495','-1' ,'1','2021-02-14'),
('502' ,'-1', '1','2021-02-14'),
('513', '-1','1','2021-02-14'),
('538', '-1','1','2021-02-14'),
('545', '-1','1','2021-02-14'),
('563', '-1','1','2021-02-14'),
('577',...

Attached excel sheet

Hi Expert,

I pump more data and tried to get values 1,0(active and inactive) order by logdate but even changing in queries not getting proper values for whole table. Sample data...

Table is attached in excel sheet due to format issue

Suggestion please