CREATE TABLE #cities(city_id INT, city_name VARCHAR(100))
INSERT INTO #cities(city_id,city_name)
SELECT 5,'New york' UNION ALL
SELECT 4,'tokyo' UNION ALL
SELECT 2,'Alaska' UNION ALL
SELECT 3,'London' UNION ALL
SELECT 1,'Banglore' UNION ALL
SELECT 1,'New york' UNION ALL
SELECT 2,'tokyo' UNION ALL
SELECT 3,'Alaska' UNION ALL
SELECT 4,'London' UNION ALL
SELECT 5,'Banglore'
And I write my queries like below:
SELECT *
FROM #cities
ORDER BY 2, 1 DESC
SELECT *
FROM #cities
ORDER BY 2 ASC, 1 DESC
As you can see both the query giving same result.
See query output
So, is there a specific use of ASC keyword in SQL Server?
