If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link
https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - Learn how to add criteria to queries in Microsoft SQL Server. This video teaches you how to use the WHERE clause to affect the number of records returned by a query, including how to add criteria to columns containing numbers, text and dates.
You can view a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s336/where_clause.htm
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit
www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Тэги:
#sql_server #criteria #WHERE #IN #BETWEEN #wise_owl