Use sum() in place of count() Try below: SELECT ccc_news . * , SUM(if(ccc_news_comments.id = ‘approved’, 1, 0)) AS comments FROM ccc_news LEFT JOIN ccc_news_comments ON ccc_news_comments.news_id = ccc_news.news_id WHERE `ccc_news`.`category` = ‘news_layer2’ AND `ccc_news`.`status` = ‘Active’ GROUP BY ccc_news.news_id ORDER BY ccc_news.set_order ASC LIMIT 20
Like this: from c in db.Company group c by c.Name into grp where grp.Count() > 1 select grp.Key Or, using the method syntax: Company .GroupBy(c => c.Name) .Where(grp => grp.Count() > 1) .Select(grp => grp.Key);
cat foo.c | sed ‘/^\s*$/d’ | wc -l And if you consider comments blank lines: cat foo.pl | sed ‘/^\s*#/d;/^\s*$/d’ | wc -l Although, that’s language dependent.
length is a property, not a method. You can’t call it, hence you don’t need parenthesis (): function getlength(number) { return number.toString().length; } UPDATE: As discussed in the comments, the above example won’t work for float numbers. To make it working we can either get rid of a period with String(number).replace(‘.’, ”).length, or count the … Read more
You can do both in one query using the OVER clause on another COUNT select count(*) RecordsPerGroup, COUNT(*) OVER () AS TotalRecords from temptable group by column_1, column_2, column_3, column_4
Perhaps table is what you are after? dummyData = rep(c(1,2, 2, 2), 25) table(dummyData) # dummyData # 1 2 # 25 75 ## or another presentation of the same data as.data.frame(table(dummyData)) # dummyData Freq # 1 1 25 # 2 2 75
try this; select gid from `gd` group by gid having count(*) > 10 order by lastupdated desc
Counting rows in big tables is known to be slow in PostgreSQL. The MVCC model requires a full count of live rows for a precise number. There are workarounds to speed this up dramatically if the count does not have to be exact like it seems to be in your case. (Remember that even an … Read more
EXISTS (or NOT EXISTS) is specially designed for checking if something exists and therefore should be (and is) the best option. It will halt on the first row that matches so it does not require a TOP clause and it does not actually select any data so there is no overhead in size of columns. … Read more
Using AWS CLI aws s3 ls s3://mybucket/ –recursive | wc -l or aws cloudwatch get-metric-statistics \ –namespace AWS/S3 –metric-name NumberOfObjects \ –dimensions Name=BucketName,Value=BUCKETNAME \ Name=StorageType,Value=AllStorageTypes \ –start-time 2016-11-05T00:00 –end-time 2016-11-05T00:10 \ –period 60 –statistic Average Note: The above cloudwatch command seems to work for some while not for others. Discussed here: https://forums.aws.amazon.com/thread.jspa?threadID=217050 Using AWS Web … Read more