0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

with T as (
select top 9
  Posts.Id, PostTypes.Name, Score
from Posts join PostTypes on PostTypes.Id = Posts.PostTypeId
order by Score desc
)
select * from T
where Name = 'answer  ' collate Latin1_general_CS_AI;

fork query

edited dec 15 23

created dec 15 23 stevekass