HELLO,
I went to get only the first row from each group by [REF]
https://techcommunity.microsoft.com/...e?v=1.0&px=999
Version imprimable
HELLO,
I went to get only the first row from each group by [REF]
https://techcommunity.microsoft.com/...e?v=1.0&px=999
Bienvenu sur le meilleur forum FRANCOPHONE...
Code:
1
2
3
4
5
6
7 ; WITH SR AS ( select ... from ...DIMTARIf ) select * from SR where [row] = 1
ROW is a SQL reserved word, so you have to put it between brackets [], or, better yet, replace it with another word like MYROW for sample ;)
En russe, d'après google traduction, ça s'écrit comme ça :
ROW - зарезервированное слово, поэтому вы должны заключить его в квадратные скобки или, еще лучше, заменить его другим словом, например MYROW
étonnant non ?