Assi9stance in a Sql statement
Hi all
I have a Table and I want to retrieve the record with the latest Sequence for each code. I need some help to write a query. Thanks to help me out.
Code Name Sequence Title
J001 John 1 Junior Administrator
J001 John 2 Administrator
J001 John 3 Senior Administrator
S001 Sue 1 Accountant
S001 Sue 2 Senior Accountant
R001 Robert 1 Manager
My desired output
J001 John 3 Senior Administrator
S001 Sue 2 Senior Accountant
R001 Robert 1 Manager
Hi allI have a Table and I want to retrieve the record with the latest Sequence for each code. I need some help to write a query. Thanks to help me out. Code Name Sequence TitleJ001 John 1 Junior AdministratorJ001 John 2 AdministratorJ001 John 3 Senior Administrator S001 Sue 1 AccountantS001 Sue 2 Senior Accountant R001 Robert 1 Manager My desired outputJ001 John 3 Senior AdministratorS001 Sue 2 Senior AccountantR001 Robert 1 Manager Read More