Hi to everyone!
Below is my data:
<caption> REVIEW CYCLE </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>
As you can see, there is duplicates in DrawingNo column. I want to create a query which would get only the DrawingNo with the latest RevisionNo which is RevisionNo 2.
Can someone help me with the code?
Appreciate your quick reply.
More powers!
Below is my data:
Detail | DrawingNo | RevisionNo | Advance Copy | Official Submittal | Date Commented | Status | ATTACHMENTS |
---|---|---|---|---|---|---|---|
4 | KAP2C1-35-AR-0400-DD-0100 | 0 | 4/20/2015 | 5/1/2015 | 5/14/2015 | Revise and Resubmit | 0 |
5 | KAP2C1-35-AR-0400-DD-0100 | 1 | 5/21/2015 | 5/27/2015 | Approved As Noted | 0 | |
6 | KAP2C1-35-AR-0400-DD-0100 | 2 | 6/1/2015 | 6/7/2015 | Approved | 0 |
<caption> REVIEW CYCLE </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>
As you can see, there is duplicates in DrawingNo column. I want to create a query which would get only the DrawingNo with the latest RevisionNo which is RevisionNo 2.
Can someone help me with the code?
Appreciate your quick reply.
More powers!