Create View Employees Hired After

nadejda91iv 11 Точки

Здравейте, може ли помощ(напътствия) как да създам view по тази задача.

Create View Employees Hired After 2000 Year

Write a SQL query to create view V_EmployeesHiredAfter2000 with first and last name to all employees hired after 2000 year.

Тагове:

02/06/2020 22:01:37 Databases Basics

Bobby_Apostolov 128 Точки

Best Answer

Здравей! Хватката е да се използва YEAR(HireDate) >2000

Може също DATEPART(YEAR, HireDate) > 2000

Ето примерно решение:
CREATE VIEW V_EmployeesHiredAfter2000 AS
SELECT FirstName, LastName
FROM Employees
WHERE YEAR(HireDate) >2000

03/06/2020 08:32:55 03/06/2020 08:37:48

nadejda91iv 11 Точки

Благодаря много:)

03/06/2020 09:31:02 03/06/2020 09:32:00