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
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  )"
merci