Get the recent record from a query that have multiple of the same records

Asked Aug 04 '22 at 03:21

Active Aug 04 '22 at 03:30

Viewed 16 times

I have to query from some tables that have duplicate records with the same unique id but I just want the recent record with that unique id

select tblEmpl.*, tblFtpTrans.actiondate, tblFtpTrans.actionflag, tblLocs.descript
from tblEmpl 
left join tblFtpTrans on tblEmpl.eight_id = tblFtpTrans.eight_id 
join TblLocs on tblLocs.location = tblEmpl.location
where (tblFtpTrans.ActionFlag='N' or tblFtpTrans.ActionFlag = 'D')
and tblEmpl.estatus='A' and tblEmpl.location='TRN'
order by ActionDate desc;

Unique Id	fname	lname	actiondate
9442	Tom	lee	2020-12-19
9442	Tom	lee	2020-10-29
3969	Pat	Ross	2015-05-21
2572	Amy	lee	2014-11-24
2572	Amy	lee	2016-04-07

What I would want is

Unique Id	fname	lname	actiondate
9442	Tom	lee	2020-12-19
2572	Amy	lee	2016-04-07
3969	Pat	Ross	2015-05-21

Any help?

edited Aug 04 '22 at 03:30

Dale K

25,246
15
42
71

asked Aug 04 '22 at 03:21

Bill Judge

Have you come across table aliases before? They make queries much easier to read. – Dale K Aug 04 '22 at 03:23
Sorry I havent @DaleK – Bill Judge Aug 04 '22 at 03:25
@DaleK Do you know how to do this with joins? – Bill Judge Aug 04 '22 at 03:29
I didn't add all the columns I need i the example that's why I needed the joins @DaleK Can you explain substitute my query – Bill Judge Aug 04 '22 at 03:31
@DaleK the row number isn't the issue so the query have multiple unique ids but I just wanted the most recent actiondate – Bill Judge Aug 04 '22 at 03:35
@DaleK Is i'm not making sense, using my query is there a way to get the most recent out that output like what I would expect that's all I'm asking using my current query – Bill Judge Aug 04 '22 at 03:43
@DaleK Can you show me a example plz? – Bill Judge Aug 04 '22 at 03:47
@DaleK Are you talking about the duplicate question? – Bill Judge Aug 04 '22 at 03:50
@DaleK Thats all you had to say – Bill Judge Aug 04 '22 at 03:51

Get the recent record from a query that have multiple of the same records

0 Answers0