I am looking for a pre-made query for Data Explorer that finds all my answers that have the most votes for questions without accepted answer.

Just want to see how many of those I have, and if possible a link to those questions.

  • 2
    Looking at your SO profile, I have to expect you know at least a little bit of SQL. Why not just write the query yourself and, if you have trouble doing so, ask for help on SO?
    – McCannot
    Jul 20, 2011 at 18:06
  • Just not so familiar with the Data Explorer database design. Jul 20, 2011 at 18:36

2 Answers 2


Not the most elegant answer (I'm not a fan of correlated sub queries), but it works and it's what I came up with first:


I've just edited Joel's code, got something that works the way I wanted:


  • You might want a LEFT JOIN rather than an INNER JOIN for the last join, otherwise you won't see questions with no other answers (unless that's what you wanted) Jul 20, 2011 at 22:06
  • I want only questions that I've answered with the highest score. So there's at least 1 answer to them. questions without answers wouldn't be needed. Thanks Jul 20, 2011 at 22:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .