All geek questions in one place

Need logic for this request?

I am new to Sql. I have two tables: 1) tblEmploee and 2) tblAgeGroup

enter image description here

enter image description here

What is the best way to get the name AgeGroupName in the tblEmploee table.

+4
source share
1 answer

Decision No. 1 -

SELECT e.*, a.AgeGroupName FROM dbo.tblEmploee e JOIN dbo.tblAgeGroup a ON e.EmpAge BETWEEN a.AgeGroupMinAge AND a.AgeGroupMaxAge

Decision No. 2 -

 SELECT * FROM dbo.tblEmploee e OUTER APPLY ( SELECT TOP 1 a.AgeGroupName FROM dbo.tblAgeGroup a WHERE e.EmpAge BETWEEN a.AgeGroupMinAge AND a.AgeGroupMaxAge ) a

Decision No. 3 -

 SELECT e.*, AgeGroupName = ( SELECT a.AgeGroupName FROM dbo.tblAgeGroup a WHERE e.EmpAge BETWEEN a.AgeGroupMinAge AND a.AgeGroupMaxAge ) FROM dbo.tblEmploee e
+6
source

Source: https://habr.com/ru/post/1494016/

More articles:


All Articles