Select query problem (1 Viewer)

[npa3000]

Hello,

I have a table called "LOADINGS". In that table there are informations about the loadings of orders.(Some orders have a lot of loadings)

For example some rows:

I want to create a query that shows me the LAST Loading Date of an order for all orders.

F.e. for the order 20220160 i must take "10/1/2022" but fot order 20220163 i have to take 13/1/2022.

I have created this query, but it shows me all the records. I know that something is missing but i cannot find that. Do you have any idea?

SELECT DISTINCT LOADINGS.ORDER_ID, LOADINGS.LOADING_DATE
FROM LOADINGS
ORDER BY LOADINGS.LOADING_DATE DESC;

 

[Ranman256]

Q1,turn on grouping sums to get the max date:
select Max(LoadingDate), OrderID from table

now that you have the max date, get the rest of the data, using Q1 joined to the table:
Q2: select * from table, Q1 where Q1.Date = table.Date and Q1.OrderID = table.OrderID

 

[plog]

To get what you want this is the SQL:

SELECT OrderID, MAX(LoadingDate) AS LastLoadingDate FROM LOADINGS GROUP BY OrderID