ORDER BY Clause - Revision history

Bacchas at 20:15, 24 October 2017

2017-10-24T20:15:19Z

← Older revision		Revision as of 20:15, 24 October 2017
Line 25:		Line 25:
	FROM customers		FROM customers
	ORDER BY state DESC, city;		ORDER BY state DESC, city;

			Reverencing Positions of sort columns in the ORDER BY

			SELECT lastname, firstname, state, city
			FROM customers
			ORDER BY 3 DESC, 4;

	[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 20:12, 24 October 2017

2017-10-24T20:12:15Z

← Older revision		Revision as of 20:12, 24 October 2017
Line 19:		Line 19:
	WHERE state = 'CA'		WHERE state = 'CA'
	ORDER BY referred NULLS FIRST;		ORDER BY referred NULLS FIRST;

			Secondary Sort

			SELECT lastname, firstname, state, city
			FROM customers
			ORDER BY state DESC, city;

	[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 20:11, 24 October 2017

2017-10-24T20:11:33Z

@@ Line 9: / Line 9: @@
   FROM publisher
   ORDER BY name DESC
 [[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]

Bacchas: Created page with " When sorting in ascending order, values are listed in this order: 1. Blank and special characters 2. Numeric values 3. Character values (uppercase first) 4. NULL values Un..."

2017-10-24T20:01:10Z

Created page with " *When sorting in ascending order, values are listed in this order: 1. Blank and special characters 2. Numeric values 3. Character values (uppercase first) 4. NULL values * Un..."

New page

*When sorting in ascending order, values are listed in this order:
1. Blank and special characters
2. Numeric values
3. Character values (uppercase first)
4. NULL values
* Unless you specify “DESC” for descending, the ORDER BY clause sorts in ascending order by default.
SELECT *
FROM publisher
ORDER BY name DESC

[[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]

ORDER BY Clause - Revision history

Bacchas at 20:15, 24 October 2017

Bacchas at 20:12, 24 October 2017

Bacchas at 20:11, 24 October 2017

Bacchas: Created page with " *When sorting in ascending order, values are listed in this order: 1. Blank and special characters 2. Numeric values 3. Character values (uppercase first) 4. NULL values * Un..."

Bacchas: Created page with " When sorting in ascending order, values are listed in this order: 1. Blank and special characters 2. Numeric values 3. Character values (uppercase first) 4. NULL values Un..."