T-SQL 101: #20 Filtering rows to return with WHERE clause predicates

added by DotNetKicks
7/8/2019 4:37:37 PM

1 Kicks, 460 Views

I showed earlier how we can retrieve data from a table using a SELECT clause. It can also be used to determine which columns are returned, and which table the data is being retrieved from. But we don't always want all the rows to be returned. The WHERE clause fixes that.