Wednesday, December 7, 2011

SQL : Numeric Order By

SELECT EmployeeID, FirstName, LastName, Address1, Address2, Telephone FROM dbo.Employees
ORDER BY 2

--This query will show your data by FirstName as it takes the Column no. 2 to sort.

No comments:

Post a Comment