I want to get the first two items of each month for each person. The idea is if the item have the same date, it should return the largest amount instead. I am having trouble writing a simple logical condition…
I am trying to figure out how to group a query result where the final Grouping should happen where the time difference is less than let's say one minute. I have watermeter that logs my water usage and I am…
I've got a simple table that has a column called Date and it stores '2015-01-15' data as an example, it ranges in '####-##-##' and there's multiple of the same dates, but following it is a number called Amount with values…
I have the next query to get the 15 most sold plates in a place: This query is taking 12 seconds to execute over 100,000 rows. I think this execution takes too long, so I am searching a way to…
I was just wondering what MySQL code could I use to find the most common value across a series of columns containing similar values. SELECT `column`, COUNT(`column`) AS `value_occurrence` FROM `my_table` GROUP BY `column` ORDER BY `value_occurrence` DESC LIMIT 1;…
This is my query in Postgresql: SELECT C.id, S.domen, B.name, C.source_id, ST.name FROM "calls" C INNER JOIN "site" S ON S.id=C.site_id INNER JOIN "sources" ON sources.id=C.source_id INNER JOIN "brand" B ON B.id = S.id_brand INNER JOIN "source_types" ST ON ST.id…
I have data that looks like this: country source 0 UK Ads 1 US Seo 2 US Seo 3 China Seo 4 US Seo 5 US Seo 6 China Seo 7 US Ads For each country I want to get…
I have the program below: void Main() { List<Online_video_for_programmers> current_year_videos = new List<Online_video_for_programmers>() { new Online_video_for_programmers { video_name="websocket for fortran programmers", season=2, seasontype=1, year=2012 }, new Online_video_for_programmers { video_name="cross site scripting for facebook addicts", season=3, seasontype=2, year=2012 }, new Online_video_for_programmers…