From the course: From Excel to SQL
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Combining filters in SQL
- So when you filter your data, sometimes it's really simple and you're just looking to filter by one condition. Without dataset, that might be filtering your data to find everyone in the marketing department. But more often than not, you're likely going to want to use multiple conditions to filter your data by. For example, when you're looking at your employee database and you want to find everyone in the marketing department, that wears a large T-shirt. So in this case, you're going to be combining filters by using the end operator. You might also want to filter your data by finding employees within the marketing or sales teams. This would be an example of combining filters using an oral operator. When working in Excel, you might choose to use a custom filter to do this. So for instance, if I want to filter by marketing and sales in the department column, I might choose text filters, custom filter, and then enter…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.