Select latest from customers table?

Please try

Select ID,     CustomerID,     DateAdded,                   PartName
from yourtable A
where ID = (select top 1 ID from yourtable where CustomerID = A.CustomerID order by DateAdded desc)

Oops I had missed table name

Select ID,     CustomerID,     DateAdded,                   PartName
from Orders A
where ID = (select top 1 ID from Orders where CustomerID = A.CustomerID order by DateAdded desc)

ok, this explains alot for me thanks :)

..but I'm still in a jam!   I actually have a second identifier in the orders table.

You see a customer might have different orders and have many items in that order.  Example:

Table: Orders

ID     CustomerID    OrderID   DateAdded                   PartName
2      5                    50          28/02/2005 16:41:37   Brush
3      7                    33          28/02/2005 16:41:37   Spade
4      5                    50          29/02/2005 16:41:37   Ladder
7      3                    23          27/02/2005 16:41:37   Gel
8      3                    24          28/02/2005 16:41:37   Frame
10    5                    65          30/02/2005 16:41:37   Paint
     

I need a select that returns to me the latest entry per customer id.  So from the above recordset I would get returned:

ID     CustomerID    OrderID   DateAdded                   PartName
3      7                    33          28/02/2005 16:41:37   Spade
4      5                    50          29/02/2005 16:41:37   Ladder
7      3                    23          27/02/2005 16:41:37   Gel
8      3                    24          28/02/2005 16:41:37   Frame
10    5                    65          30/02/2005 16:41:37   Paint


So it pick id 3 out, as customer 7 has only one order

It picks ID 4 and 10 from customer 5 as they are in different orders, but drops ID 2 since it belongs to order 50, but id=4 is newer

Does that makes sense?

Spot on! thx Hilaire :)

Ah! :(   ..looks like the code doesn't work afterall :(

Can this be reopened please?


Code:
Select ID,     CustomerID,     DateAdded,                   PartName
from Orders A
where ID = (select top 1 ID from Orders where CustomerID = A.CustomerID and OrderID = A.OrderID order by DateAdded desc)


The problem is with "and OrderID = A.OrderID"  line, it seems to only take the latest orderid of the same value.

Example
Table: Orders

ID     CustomerID    OrderID   DateAdded                   PartName
2      5                    50          28/02/2005 16:41:37   Brush
3      7                    33          28/02/2005 16:41:37   Spade
4      5                    50          29/02/2005 16:41:37   Ladder
7      3                    23          27/02/2005 16:41:37   Gel
8      3                    50          28/02/2005 16:41:37   Frame
10    5                    65          30/02/2005 16:41:37   Paint

Where you can see custid 3 and 5 have an orderid of 50, it would only take the latest order of the orderid=50, in this case, row id 4.

Any thoughts?

Erm, lol scrap that it does work...the code I used working on the theory of this code was incorrectly typed.

glad you could sort it out by yourself
have a nice day
Hilaire

Thanks for checking back Hilaire. :)

I've got an extended question based on your code, found here:
https://www.experts-exchange.com/questions/21481732/Select-latest-from-customers-table-PART-DEUX.html

;)