What is the use of ASC keyword in SQL Server as ASC is the default?

Viewed 12212
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

enter image description here

So, is there a specific use of ASC keyword in SQL Server?

4 Answers
Related