SQL Server: A query with an ORDER BY clause cannot be used as a table expression
Hi Friends, Assume an Orders table with 2 columns (OrderID, customerID) and we try to write the following query: USE NORTHWIND GO SELECT * FROM (SELECT orderid, customerid FROM dbo.Orders ORDER …
SQL Server: A query with an ORDER BY clause cannot be used as a table expression Read More