Query problem

[akinia]

Hi every one,

I've a little problem to acheive this query.
There is table with the following fields:
Empl_No
Date(Numeric)
Group_Nr

Now the datas:
001 001 001 001
5400 5440 5470 5485
A B C A

I need to retrieve the group at a distinct date; for example
I need the last group for the date before 5475. The result is C.

Any help will be appreciated.

Thanks in advance ;-)

 

[akinia]

Hi,

After a good reflexion and many tests, I've finally found the solution.
Here is the SQL :

SELECT EMPL_NO, MAX(Date) as MaxDate,
(SELECT Group_Nr FROM <Table_Name> TN WHERE
TN.Date = Max(S.Date) as Grp
FROM <Table_Name> S WHERE Date <= <Date> GROUP BY
EMPL_NO

Sorry for this thread ; I hope it could help somebody.

;-))