Duration: 18:34 min
Summary: In this video, we will continue the select statement discussion. We will build on what we have learned so far. We start with a simple select statement that returns all the records from the department table, then we add a where clause to return specific records. In the process, we will learn about different operators that work with numbers, strings and dates. We will also explore the ‘like’ operators to return records that partially match what we have. Finally, we will also discuss how to return a number of records from a table using the ‘top’ option.
Technologies and Resources: T-SQL, SQL Server 2012 Express, AdventureWorks 2012, Database, Select.