bonjour
je souhaite récupérer la plus petite et la plus grande valeur entre 2 dates
exemple
ID STA_SiteNumber INF_NumberInStation INF_Date INF_Value 0001400001 14 1 2020-09-18 09:00:00.0000000 0 0001400001 14 1 2020-09-18 09:39:33.0000000 5 0001400001 14 1 2020-09-18 09:39:34.0000000 10 0001400001 14 1 2020-09-18 09:39:35.0000000 11 0001400001 14 1 2020-09-18 10:00:00.0000000 11 0001400001 14 1 2020-09-18 10:08:56.0000000 12 0001400001 14 1 2020-09-18 10:08:57.0000000 14 0001400001 14 1 2020-09-18 11:00:00.0000000 15 0001400001 14 1 2020-09-21 07:00:00.0000000 15 0001400001 14 1 2020-09-21 08:00:00.0000000 15 0001400001 14 1 2020-09-21 09:00:00.0000000 15 0001400001 14 1 2020-09-21 10:00:00.0000000 15 0001400001 14 1 2020-09-21 11:00:00.0000000 15 0001400001 14 1 2020-09-21 12:00:00.0000000 15
et je souhaite ceci
ID STA_SiteNumber INF_NumberInStation INF_Date INF_Value 0001400001 14 1 2020-09-18 09:00:00.0000000 0 0001400001 14 1 2020-09-21 12:00:00.0000000 15
j'ai dans une dernière demande ceci
merci
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5 " SELECT T1.ID , T1.STA_SiteNumber, T1.INF_NumberInStation, T1.INF_Date, T1.INF_Value " _ & " FROM dbo.View_ArchivedInformations AS T1 " _ & " WHERE ((T1.STA_SiteNumber = 16 or T1.STA_SiteNumber = 15 or T1.STA_SiteNumber = 14 )and T1.INF_NumberInStation < 49) " _ & " AND T1.INF_Date= (SELECT MAX(S1.INF_Date) " _ & " FROM dbo.View_ArchivedInformations AS S1 WHERE S1.ID = T1.ID )"
Partager