1. Learn
    2. /
  2. Courses
    3. /
  3. Hierarchical and Recursive Queries in SQL Server

Exercise

A CTE for IT-positions

Let's practice writing CTEs. You will use the employee table which is built up of fields such as ID, Name, and Position. The task for you is to create a CTE called ITjobs that finds employees starting with A whose job titles start with IT. Your new query will retrieve all IT positions and names from the ITJobs CTE.

To search for a pattern, you have to use the LIKE statement and % representing the search direction. For example, using a WHERE statement with LIKE 'N%' will find patterns starting with N.

Instructions

100 XP
  • Create the ITjobs CTE.
  • Define the fields of the CTE as ID, Name, and Position.
  • Find the positions starting with IT and the name starting with A.