Demonstration should include using the WHERE clause to restrict the selection of all data in a table as opposed to only the data useful for answering a question. The WHERE clause should be used to narrow, or filter, results for precision and accuracy.
Related Standards of Learning
The student will select and call library functions to process data, as appropriate.
The student will implement various mechanisms for performing iteration with an algorithm
Other Related Standards
Microsoft Imagine Academy Resources
[3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2