Tutorial SQLServer 13

1 Microsoft SQL Server and the SQL Server Management Studio
2 RealEstate1New Query
Silver SpringMaryland
Maryland

Silver Spring

SQLAND
SELECT WhatColumn(s)
FROM WhatObject
WHERE Condition1 AND Condition2
WhatColumn(s)WhatObjectAND
Column operator Value

Condition1
Maryland
SELECT FirstName, LastName, Gender, City, State
FROM Students
WHERE Gender = 'female' AND State = 'md';

NOT
1 Sliver Spring
SELECT h.PropertyNumber AS [Prop #],
h.PropertyType AS Type,
h.YearBuilt AS [Year Built],
h.City,
h.State,
h.ZIPCode AS [ZIP Code],
h.Bedrooms AS Beds,
h.Bathrooms AS Baths,
h.MarketValue AS Value
FROM Properties h
WHERE (h.PropertyType = 'Single Family') AND (City = 'Silver
Spring');
GO
2 F5
3
400،000
400،000
SELECT h.PropertyNumber AS [Prop #],
h.PropertyType AS Type,
h.YearBuilt AS [Year Built],
h.City,
h.State,
h.ZIPCode AS [ZIP Code],
h.Bedrooms AS Beds,
h.Bathrooms AS Baths,
h.MarketValue AS Value
FROM Properties h
WHERE (h.PropertyType = 'Townhouse') AND (h.MarketValue < 400000);
GO
4 F5