I have a table I? L? V1 1?? A1 2?? A1 3?? A1 4?? B1 5 ? B1 6?? A1 7?? A2 1 ? C2 2?? C I want to return the minimal and maximum L for each "group" of V in a given I.
The result I want: I? MinL? MaxL? V1? 1??????? 3? ???????? A1? 4??????? 5?????????? B1? 6??????? 7?????????? A2? 1??????? 2?????????? C I know I can't just do ?? SELECT I, MIN(L) as MinL, MAX(L) as MaxL, V? FROM T ? GROUP BY I, Vsince that would return min/max of 1 and 7 for A, instead of the 2 lines I need. So should I word the SELECT statement? Thanks,David
