I need to select the Top row of the table and the bottom row of the table from the CUSTOMERORDER table not sure how to do it. I'm running SQL server 2012.
This is what i have so far.
select *, CompanyName, Phone, lastname, orderdate
inner join Employee
on Customer.AcctRepNo = Employee.EmpNo
inner join CustomerOrder
on Customer.CustNo = CustomerOrder.CustNo