This is my data , employee_id name manager_id salary 1 Alice 100000.00 2 Bob 1 80000.00 3 Charlie 1 75000.00 4 David 2 60000.00 5 Eve 2 50000.00 6 Frank 3 55000.00 Question is The total salary paid under each…
I have two tables, lets call them t1 and t2. Fiddle select setseed(.42); create table t1(a,b,c,d)as select (random()*9)::int , (random()*9)::int , (random()*9)::int , (random()*9)::int from generate_series(1,100); create table t2(a,b,c,d)as select (random()*9)::int , (random()*9)::int , (random()*9)::int , (random()*9)::int from generate_series(1,200); I'm…
I have such MySQL code: SELECT departmentId, name, salary, DENSE_RANK() OVER (PARTITION BY departmentId ORDER BY salary DESC) AS salary_rank FROM Employee HAVING departmentId = 1 This works properly as expected but if I change the HAVING clause as SELECT…
I have a large CSV file that I need to update into a PostgreSQL database. I am considering two different approaches and would like to know which one is faster for updating very large data. Here are the two approaches:…
How would one have dynamic "secondary" keys? For example, how we have it in Jira. We have a project name, for example "Test" with the shortcut "TEST". All associated tickets in this project are given a ID "TEST-1234", "TEST-1235", and…
I have a table named "liverpool_players" and I'm trying to create a new one with an additional column "years_at_club", which I mean for to be autogenerated as at date 31 Dec 2024. I run the following sql statements in PostgreSQL:…
I am in need to use the Word Boundary(y) as a condition to match the exact word which is been searched as a Query Param. I am writing this regex and executing in PostgreSQL but it is returning FALSE. text_search_value…
I want to splits a string on '_' and replace 3rd group with 'oooo'. Is there any way to do it simply and without assuming there's exactly 5 groups? CONCAT( SPLIT_PART(test, '_', 1) ,SPLIT_PART(test, '_', 2) ,'OOOO' ,SPLIT_PART(test, '_', 4)…
In my Postgres table I’ve got two columns, one of them sometimes have strings, the other one is empty, but some strings from first column sometimes has substrings, I want to move data from first column to another if it…
I have a table in BigQuery where I would like to be able to group according to some type of mapping file, for example if I had the following Product Code Country Sales AA1 US 5 AA2 US 10 AA1…