I have these results: With the table like: These are grouped by the person. Now I’m looking to add a column with the percentages for each person calculated from the total of all of their sums. For example: the total sum is 300, and hence I need a result like this: I have looked at code online and I have
Tag: sql
How to get maximum number of concurrent events in postgresql?
I have a table named events like this: These events could have overlaps, and I want to know maximum number of overlapping events that have occurred over a time span. For example, in a situation like this: The answer is 2, because at most 2 events overlap at 10:30 until 10:35. I’m using Postgres 9.6 Answ…
Case When syntax expression in jooq
I am trying to reproduce this MySQL query in jooq to Answer What you seem to be looking for is the SQL:2003 simple CASE expression, which allows to form something like “partial predicates” based on the case value, akin to pattern matching in other languages. This is not yet supported in jOOQ, see …
How can I have IS NULL condition in TypeORM find options?
In my queries I’m using TypeORM find option. How can I have IS NULL condition in the where clause? Answer Another way is you can use IsNull() function, for example:
Making dynamic SQL queries to a MySQL DB
I’ve never used golang with mysql before, so I’m reading about these for the first time. I’d like to do something like this: This is far too much typing, especially if I have a dozen more variables I’d like to add to the WHERE condition. If this were PHP, I’d do something like th…
SQL Insert Into New Table from Old Table
I’ve got two table which are near identical, the only difference is the newer one has different field names. Basically the old table was outdated and needed to be re-worked; I’m trying to extract all the field where the VendorNumber = Vendor_ID all the field that are being copied to are guaranteed…
Concatenate with string but exclude when null
Oracle v11 Exclude a string in a Concat when the value is NULL? Work Query: TableA Output I’m getting Expected Output: Answer Something like this… I added simulated inputs to test all four possibilities. However, note that if you may have last name but no first name, and also first name but no las…
Finding the maximum distance between events in a group in gdelt-bq.full dataset, BigQuery
I need to find the longest distance across all the event points for each country in gdelt-bq.full:events dataset. For having information about countries make groups there is a join with gdelt-bq:extra.countryinfo. So now I have this table: The difficulty is that there are around 50k events in total, and maxim…
How to find duplicate rows in Hive?
I want to find duplicate rows from one of the Hive table for which I was given two approaches. First approach is to use following two queries: second query is as below which will give count of distinct rows With this approach, for one of my table total row count derived using first query is 3500 and second qu…
Convert time float to format HH:mm sql server
I need to format a float decimal number into a time format hour:minute. I wrote this Scalar-Value Functions with an input float and output varchar(6): It looks like great, but not for everything records. This is my output: As you can see from the results, there are 3 wrongs conversion: 0.33 = 00:19 // 0.58 = …