do our sorting using numeric fields : Order by « Query « SQL Server / T-SQL Tutorial

7> CREATE TABLE Products (
8>      ProductID int NOT NULL ,
9>      ProductName nvarchar (40) NOT NULL ,
10>     SupplierID int NULL ,
11>     CategoryID int NULL ,
12>     QuantityPerUnit nvarchar (20) NULL ,
13>     UnitPrice money NULL,
14>     UnitsInStock smallint NULL,
15>     UnitsOnOrder smallint NULL,
16>     ReorderLevel smallint NULL,
17>     Discontinued bit NOT NULL
18> )
19> GO
1> INSERT Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(71,'F',15,4,'10 - 999 g pkgs.',61.5,66,6,6,6)
2> INSERT Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(72,'M',14,4,'24 - 888 g pkgs.',34.8,74,7,7,7)
3> INSERT Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(73,'R',17,8,'24 - 777 g jars',17,171,0,5,0)
4> INSERT Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(74,'L',4,7,'5 kg pkg.',10,4,20,5,0)
5> INSERT Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(75,'R',12,1,'24 - 0.5 l bottles',1.23,445,0,25,0)
6> INSERT Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(76,'L',23,1,'500 ml',18,57,1,20,0)
7> INSERT Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(77,'O',12,2,'12 boxes',13,23,0,15,0)
8> go

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)
1>
2>    SELECT ProductID, ProductName, UnitsInStock, UnitsOnOrder
3>    FROM Products
4>    WHERE UnitsOnOrder > 0
5>    AND UnitsInStock < 10
6>    ORDER BY UnitsOnOrder DESC
7> GO
ProductID   ProductName                              UnitsInStock UnitsOnOrder
----------- ---------------------------------------- ------------ ------------
         74 L                                                   4           20

(1 rows affected)
1>
2> drop table products;
3> GO

1.3.Order by
	1.3.1.	The expanded syntax of the ORDER BY clause
	1.3.2.	ORDER BY Clause: ORDER BY {[col_name \| col_number [ASC \| DESC]]}, ...
	1.3.3.	Sorting your grouped results with ORDER BY clause.
	1.3.4.	An ORDER BY clause that sorts by one column in descending sequence
	1.3.5.	the order criterion may contain more than one column.
	1.3.6.	An ORDER BY clause that sorts by three columns
	1.3.7.	An ORDER BY clause that uses an alias
	1.3.8.	An ORDER BY clause that uses an expression
	1.3.9.	An ORDER BY clause that uses column positions
	1.3.10.	Sorting your grouped results by an aggregate.
	1.3.11.	NULLs Sort Last
	1.3.12.	order criterion contains any aggregate function.
	1.3.13.	Order by not null date
	1.3.14.	Using the TOP keyword with Ordered Results
	1.3.15.	do our sorting using numeric fields
	1.3.16.	use CAST function to sort during ordering