Select

Select all

SELECT * FROM SchemaName.TableName

Select Some Fields

SELECT Id,
	OtherField,
	Price
FROM SchemaName.TableName

Alias

SELECT tn.Id,
	tn.OtherField,
	tn.Price
FROM SchemaName.TableName AS tn