Cross queries SQL

xiaoxiao2021-03-06 74

SQL:

Select GWLB, Count (Case When (Year (Year (Year (Year (Year (Year (Year (Year () ") Between 20 and 30 Ten Rygh End) AS '20 -30 ',

Count (Case When) - Year (RybpterHDay)) BetWeen 30 and 40 Ten Rygh End) AS '30 -40 ',

Count (Case When (Year (getDate ()) - Year (RybpterHDay)) BetWeen 40 and 50 Ten Rygh End) AS '40 -50 ',

Count (Case When (Year (Year (a GetDate ()) - Year (RybpterHDay)) Between 50 and 60 Ten Rygh End AS '50 -60 ',

Count (Case When) - Year (RybpterHDay) BETWEEN 60 and 70 TEN RYGH END) AS '60 -70 '

From t_ry

Group by gwlb

转载请注明原文地址:https://www.9cbs.com/read-93188.html

9cbs

New Post(0)