Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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.

share|improve this question
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 '11 at 18:06
Just not so familiar with the Data Explorer database design. – Yochai Timmer Jul 20 '11 at 18:36
up vote 3 down vote accepted

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:

share|improve this answer

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

share|improve this answer
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) – Joel Coehoorn Jul 20 '11 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 – Yochai Timmer Jul 20 '11 at 22:07

You must log in to answer this question.

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