Query to get First and Last record from Table in SQL Server

Last Reply 10 months ago By pandeyism

Posted 10 months ago

I have bunch of Invoices I need First Invoicenumber and last invoice number in side by side

InvoiceNum
INV001
INV002
INV003
INV004

Output

FirstInvoice LastInvoice
INV001 INV004
This question does not have replies that have been liked.