Job offersCompaniesTestsBlogI'm an employerSign upLog in
Home>IT Tests>Questions>Retrieve employees' names and job titles from the "Sales" department hired after January 1, 2020.

Question from the SQL - Fundamentals test

Retrieve employees' names and job titles from the "Sales" department hired after January 1, 2020.

Easy

Write an SQL query to retrieve the names and job titles of all employees in the "Sales" department who have been hired after January 1, 2020.

Author: Elham JafariStatus: PublishedQuestion passed 16 times
Edit
0
Community Evaluations
developer avatar
Dragon parfait
08/11/2024
Added french version. Thanks for your contribution Elham !
Similar Questions
More questions about SQL
29
Write a SQL query to retrieve the list of employees with a salary greater than 5100.
14
Select only distinct values in a column using SQL
14
Update a column in an SQL table
12
Write a SQL query to insert data into a table
12
Which SQL keyword is used to sort the result of a SELECT statement?