Hello !
SQL-Syntax help needed.
I have a maxdb table with the complete purchase orders from the last 10
years !
partno, supplierno, date, amount, price .... (250000 records)
For all partnos there can be orders from different supplieres with
different prices
I have the transfer the "latest price informations" for each
partno/supplier to another system
I do a "select * order by partno,supplierno, date desc"
But i want to extract only the last 2 orders for each partno,supplier
kombination
Can this be done with one sql-command ???
If not, how to code ??
Any help welcomed
Best regards
Albert Beermann
'''''
'''''''''
(0 0)
+---------oOO-------(_)-------------------+
| Tel: 0541/5841-868 |
| Fax: 0541/5841-869 |
| Mail: mailto:[EMAIL PROTECTED] |
| Internet: http://www.piepenbrock.de |
+-------------------------------oOO-------+
|__|__|
|| ||
ooO Ooo
