Tutorial SQLServer 12

SELECT
SQL
 Sort Type
1
Sort
Filter

Ascending
 charvarchar
 datetimesmalldatetime
 bitFalse
SQL Server Management Studio RealEstate1
SQLORDER BY
SELECT What FROM WhatObject ORDER BY WhatField;
LastName

SELECT FirstName,
LastName,
Gender,
ParentsNames,
SPHome
FROM Students
ORDER BY LastName;
GO
SELECT FirstName, LastName, Gender, EmailAddress
FROM Students
ORDER BY Gender;

GO
LastName
SELECT * FROM Students
ORDER BY LastName;
GO
ASC
SELECT * FROM Students
ORDER BY LastName ASC;
GO
DESC
SELECT FirstName,
LastName,
Gender,
ParentsNames,
SPHome
FROM Students
ORDER BY LastName DESC;
GO

1
SELECT house.YearBuilt AS [Year Built],
house.PropertyType AS [Type],
house.Bedrooms AS [Beds],
house.Bathrooms AS [Baths],
house.MarketValue AS [Value]
FROM Properties house
ORDER BY house.MarketValue
GO
2 F5