确定关系 [英] Identify Ties

问题描述

你们一直很棒！谢谢你的帮助。我正在学习... ...


所以现在我有一份有关获奖者名单的工作SQL声明，我需要一份新的报告，显示只有TIE得分在获胜者名单的前3名中，我可以在给予奖杯之前快速查看领带问题。


以下是示例数据：

You guys have been great! Thank you for all your help. I am learning as I go...

So now that I have a working SQL statement for a winner''s list, I need to have a new report that shows ONLY TIE score in the top 3 from the winner''s list so that I can quickly see tie problems before giving trophies out.

Here is the sample data:

展开 | 选择 | Wrap | 行号

推荐答案

您的查询与您的查询大致相似。你 需要一个HAVING子句。我认为以下内容应该有效。尝试一下：

Your query qould be largely similar to what you have. You would need a HAVING clause. I think the following should work. Try it out :

展开 | 选择 | Wrap | 行号

如果我尝试保存以下SQL，则保存正常。

然后运行它，我得到不能在用''''选择的字段上分组（Dupe）"

然后我回到查询编辑器（不是SQL视图）这一切都搞砸了......

If I try to save the following SQL it saves ok.
Then run it and I get "cannot group on fields selected with ''*''(Dupe)"
Then when I go back into query editor (not SQL view) it is all messed up...

展开 | 选择 | Wrap | 行号

你从我的建议做了各种改变。我很乐意使用我建议的代码，但是当你做出一系列改变 - 其中一些是风格而另一些更基础 - 那么，如果我要回答你的问题，我会'我处于一个很大的劣势。我必须从头开始。这可能会让你感到厌倦，因为我相信你会欣赏。


如果我能帮助你前进，那么你需要处理我的建议。测试它们并报告你得到的东西。这样我们都知道我们在哪里。如果你测试它们然后继续你自己的想法而不报告，我会落后，这一切都变得比它需要的复杂得多。

You have made various changes to this from what I suggested. I''m happy to work with code I''ve suggested, but when you make a bunch of changes - some of which are stylistic while others are more fundamental - then, if I''m to answer your questions, I''m at a big disadvantage. I have to start again from scratch. That can get tiresome as I''m sure you can appreciate.

If I''m to help you go forward then you need to work with my suggestions. Test them out and report on what you get. That way we both know where we are. If you test them then go ahead with your own ideas without reporting back, I get left behind and it all gets much more complicated than it needs to be.

这篇关于确定关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！