SELECT [Datetime]
FROM [mydbtemp]
WHERE [Tagvalue] = 1
AND [Datetime] > (SELECT MAX([Datetime])
FROM [mydbtemp]
WHERE [Tagvalue] = 2
AND [Datetime] BETWEEN '2023-02-01 01:00:00' AND '2023-02-05 20:00:00')
AND [Datetime] BETWEEN '2023-02-01 01:00:00' AND '2023-02-05...

• This reply was modified 1 year, 8 months ago by  lalitprg2017.

SELECT [Datetime] 
FROM [mydbtemp] 
WHERE [Tagvalue] = 1 
AND [Datetime] > (SELECT MAX([Datetime]) 
FROM [mydbtemp] 
WHERE [Tagvalue] = 0 
AND [Datetime] BETWEEN '2023-02-01 01:00:00' AND '2023-02-05 20:00:00')...

The Result which i ma getting is not as i required it shows the recent value after running the above-mentioned query whereas the result should be as shown in the...

I already shared the screenshot of the table and query for the result i am expecting

Thanks  a Ton You made my day This worked Perfectly

I wanted to display the value which are greater than 0 in just 3 columns as shown in the table2 I wrote the below query but quite doesnt work

SELECT

ITEM

, COALESCE(PWT,...

Yes You understand it correctly there will be multiple tables which are identical in both the DBs