Search results
-
L
count if and where
many thanks. not quick as you say, but only needs running once in a while when new data added. much appreciated -
L
count if and where
the query is meant to let me know how many of each event type are left to occur in the game after each minute. so in the above example 67343499 the away corners occurred in the 86th and 90th minutes. so it would return 2 for minutes 0 to 85 (since 2 corners are still to occur), 1 from 86 to 89... -
L
count if and where
hi plog, I have responded but no idea why it's not on site. will re-reply later. -
L
count if and where
67343499 c a 90+2 90 67343499 c a 86 86 67343499 g h 72 72 67343499 g h 55 55 67343499 c h 37 37 67343499 c h 28 28 67343499 c h 24 24 67343499 c h 16 16 67343499 c h 6 6 67343499 c h 4 4 etc referred to all minutes from 0 to 90 so for the... -
L
count if and where
i'm looking to build a query that will give me a count of away team (h=a) corners (tp=c) where the time (t_val) if greater than 0, 1, 2, 3 minute etc for each id. So i get a count of how many corners etc are yet to be scored in the game. so id 67343499 away corners >45 (ie second half) = 2... -
L
Delete Duplicates
well i'm not sure it is? the uniqeness is relative to the prior row, not all rows -
L
Delete Duplicates
Sorry, I've not made it at all clear. The price rows are time sequential. Prices can go up and down and I want to keep all rows where there is a new price. So for example prices might do this over time:- 1.8* 1.8 1.78* 1.78 1.78 1.77* 1.77 1.78* 1.80* So the rows I want to keep are '*'... -
L
Delete Duplicates
Hi I need to delete duplicate rows (or create new table without them) but the duplicate is not the entire row of data. Date Time LeagueMatchingId League HomeMatchingId HomeName AwayMatchingId AwayName HomeScore AwayScore HomeRedCardCount AwayRedCardCount FTOU FTOverOdds FTUnderOdds...