English 中文(简体)
查询没有COUNT或SUM的方面的唯一组合的数据?
原标题:Query data for unique combinations of facets without COUNT or SUM?

我目前正试图提出一个比目前更好的问题。出于分析的原因,我想看看某个记录的不同方面的组合。目前我使用SELECT COUNT(myRecord)FROM Metric FACET foo,bar。这就完成了任务,但我想知道是否有可能更有效地聚合数据。我使用COUNT将值分组在一起,但我最终不关心COUNTed和。有没有更好的方法来编写这个不执行额外计算的查询?

问题回答

暂无回答




相关问题
Response is not fully loaded

We are using react js as front end and Java( maven) as backend. we have included the new relic script in the index.html page which is not allowing the full response to load. Therefore the application ...

NewRelic Always Says My App Is Down

I have the NewRelic addon installed on my Heroku application and I m attempting to use their "Availability" feature but it aways says that my app is down. Also, if I try to change the URL that I want ...

Rails syntax error in YAML file?

Why am I getting the following error when I run rails console? NOTE: Gem.available? is deprecated, use Specification::find_by_name. It will be removed on or after 2011-11-01. Gem.available? called ...

Zend Server vs newrelic

I need to select one solution for deep monitoring of a production environment based on PHP and MySQL. Help us discover and recreate bugs that made it into the production environment Help us profile ...

newrelic_rpm,rails gem showing no route in development

i need to check the performance of my rails application. i installed newrelic_rpm. In environment.rb , the following added: config.gem "newrelic_rpm" then, in browser i gave: http://localhost:3000/...

热门标签