AdventureWorks Database: Retrieve individuals using multiple conditions

SQL Query - AdventureWorks: Exercise-44 with Solution

44. Create a SQL query to retrieve individuals from the following table with a businessentityid inside 1500, a lastname starting with 'Al', and a firstname starting with 'M'.

Sample table: Person.Person

Click to view Full table

Sample Solution:

SELECT businessentityid, firstname,LastName  
FROM person.person 
WHERE businessentityid <= 1500 AND LastName LIKE '%Al%' AND FirstName LIKE '%M%';

Sample Output:

businessentityid|firstname|lastname |
----------------+---------+---------+
             327|Milton   |Albury   |
             335|Michelle |Alexander|
             341|Marvin   |Allen    |
             343|Michael  |Allen    |
            1149|Mary     |Alexander|

SQL AdventureWorks Editor:

Practice Online

Contribute your code and comments through Disqus.

Previous: Retrieve individuals using multiple conditions.
Next: Using a derived table with multiple values.