Writing a SELECT statement
What are the basics in writing a T-SQL SELECT? How to return columns and records from a table in SQL Server.
SELECT
Filtering Records by Numbers
How to use the WHERE statement to filter records when the value is a number or integer data type in a T-SQL statement.
Filtering Records by Character Data
How to use the WHERE statement to filter records when the value is a character data type in a T-SQL statement.
Using GROUP BY and HAVING
In this post, we discuss how to use the GROUP BY and HAVING clause in a T-SQL statement and how to use them with aggregate functions.