top questions without accepted answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

DECLARE @UserId int = ##UserId##

SELECT top 1000
    id  as [Post Link],Title,AnswerCount,
    Score
FROM 
    Posts
WHERE 
    (AcceptedAnswerId is null)
    and answercount<10
    and ClosedDate is null
    and (tags like '%c#%' or tags like '%sql-server%'
     or tags like '%go%'
     or tags like '%aspnet%'
     or tags like '%mvc%'
     or tags like '%html%'
     or tags like '%dotnetcore%') 
    --and CreationDate>'2018-01-01'
ORDER BY 
    Score DESC,ViewCount desc,creationdate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results