SELECT
ROW_NUMBER() OVER(ORDER BY orderid) AS rownum,
orderid, CONVERT(varchar(10), orderdate, 120) AS orderdate,
empid, custid, qty
FROM dbo.Orders AS O1
ORDER BY orderid