0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

with a as 
(select *,
        Case
           When displayname like '%reinstate%' collate SQL_Latin1_General_CP1_CI_AS
           Then 10
           When displayname like '%fund%' collate SQL_Latin1_General_CP1_CI_AS
           Then 9
           When displayname like '%says%' collate SQL_Latin1_General_CP1_CI_AS
           Then 8
           When displayname like '%support%' collate SQL_Latin1_General_CP1_CI_AS
           Then 7
           When displayname like '%je suis%' collate SQL_Latin1_General_CP1_CI_AS
           Then 6
           When displayname like '%wants%' collate SQL_Latin1_General_CP1_CI_AS
           Then 5
           When displayname like '%justice%' collate SQL_Latin1_General_CP1_CI_AS
           Then 4
           When displayname like '%stands%' collate SQL_Latin1_General_CP1_CI_AS
           Then 3
           When displayname like '%apolog%' collate SQL_Latin1_General_CP1_CI_AS
           Then 2
           When displayname like '%cellio%' collate SQL_Latin1_General_CP1_CI_AS
           Then 1
           When displayname like '%races%' collate SQL_Latin1_General_CP1_CI_AS
           Then 1
           Else 0
         End   addition 
 from users)
select displayname, addition, count(displayname) OVER(ORDER BY addition Desc)
from a
where displayname like '%Monica%' collate SQL_Latin1_General_CP1_CI_AS
order by addition Desc

fork query

edited nov 9 19 anonymous

created nov 8 19 rene