selecting the last 3 orders made

[noks]

Hi guys

Am new in SQL server. i use SQL server 2003 ans am trying to retieve the last three orders made. Can you please help me with my Select statement so that it will only select the last three coz @ the moment it selects everything

CODE:
SELECT dbo.Invoice.Inv oiceNo, dbo.Sales.Units Sold, dbo.Sales.Quant itySold, dbo.Sales.CostA mount, dbo.Item.ItemCo de, dbo.Item.ItemDe scription,
dbo.Item.Item, dbo.PurchaseOrd er.OrderNumber, dbo.PurchaseOrd er.OrderDate, dbo.PurchaseOrd er.OrderStatus, dbo.PurchaseOrd er.QuantityOrde red,
dbo.PurchaseOrd er.QuantityRece ived, dbo.Customer.Cu stomerCode
FROM dbo.Invoice INNER JOIN
dbo.Sales ON dbo.Invoice.Inv oiceKey = dbo.Sales.Invoi ceKey INNER JOIN
dbo.Item ON dbo.Sales.ItemK ey = dbo.Item.ItemKe y INNER JOIN
dbo.PurchaseOrd er ON dbo.Sales.Vendo rKey = dbo.PurchaseOrd er.VendorKey INNER JOIN
dbo.Customer ON dbo.Sales.Custo merKey = dbo.Customer.Cu stomerKey

Thanks
Noks

[Arnold Schuur]

You have to sort the order records descendending by for example orderDateTime or OrderId and then take the top 3 records.

Pseudo code:

SELECT TOP 3 * FROM ORDERS ORDER BY ORDER_DATE_TIME DESC