I have a summary query in Access which has several Fields that use the First Or Last options. There is no equivolent function in Oracle. Does anyone know how to do this in oracle?
Simplified version of Access Query:
SELECT CustName, First(AcctType), Last(SalesPerson), Sum(MonthlySales) FROM CustSales WHERE SalesMonth Is Not Null And SalesYear = 2007 GROUP BY CustName;