Table structure

EMP (Integer)
DAT (Date)
SEQ (Integer)
Other fields

Data sample:

EMP  DAT             SEQ
1        2012-03-01   1
1        2012-03-01   2
1        2012-03-01   3 *
1        2012-03-02    1
1        2012-03-02    2 *
1        2012-03-03    1 *

I would like to get the last occurrence of the last the key EMP + DAT + SEQ
(the records with *)

With the following SQL I get the keys but I need the "other fields".
How can I do that ?

select emp,dat,max(seq) from table group by emp,dat

Eduardo

Eduardo
> Table structure
>
> EMP (Integer)
> DAT (Date)
> SEQ (Integer)
> Other fields
>
> Data sample:
>
> EMP  DAT             SEQ
> 1        2012-03-01   1
> 1        2012-03-01   2
> 1        2012-03-01   3 *
> 1        2012-03-02    1
> 1        2012-03-02    2 *
> 1        2012-03-03    1 *
>
> I would like to get the last occurrence of the last the key EMP + DAT + SEQ
> (the records with *)

One way would be to do it in 2 stages with a script eg

select emp,dat,max(seq) as seq into memory\temp from table group by emp,dat;
select emp,dat,seq,otherfields from memory\temp join table on temp.emp=table.emp and temp.dat=table.dat and
temp.seq=table.seq

John

John

Thanks for your tip.

Eduardo