Write a solution to find the second highest salary from the Employee table. If there is no second highest salary, return null. This is my code: select ifnull(x.salary,NULL) as SecondHighestSalary from( select *, dense_rank() over( order by salary) as rnk…
I have a table that stores the same phone numbers but with different attributes. Without changing the schema, I want to group up all the phones and sort them by their createdat and organizationid parameters. Here is an example: Unordered…
I am developing job portal similar and I had postgresql table job_seeker with column name skill holds the job seeker skills as comma separated values table name - job_seeker columns - id name skills values(data) -1 mahesh java,spring,mysql 2 rakesh…
There are numerous SQL questions and answers about finding gaps in sequences, but I could not find any that have the wrinkle my situation has: I need to group the sequence by another column. My table (simplified) id | parent_id…
I have an input table like this: Load_date projected_date current stock consumed demand 2020-01-01 2020-01-01 100 15 2020-01-01 2020-01-02 150 80 2020-01-01 2020-01-03 200 25 2020-01-01 2020-01-04 300 70 2020-01-01 2020-01-05 400 65 My intermediate output will be like this:…
On postgresql@12 I have a table with 300 millions rows and first query executes < 1s, but the second is 2 minutes. Why? I created all possible indexes. First query (< 1s): SELECT hash FROM _transfers WHERE (from_='abcd' or to_='abcd')…
I have three tables: conversations, user_messages and system_messages. Their basic structure (irrelevant columns removed for brevity) is: create table conversations(id int generated by default as identity primary key); create table user_messages( id int generated by default as identity primary key…
I'm facing a problem where my syntax in PhpMyAdmin got an error this is my code CREATE PROCEDURE `tambah_semua`(IN `Nama` VARCHAR(255), IN `Plat_Nomor` VARCHAR(8), IN `Deskripsi` TEXT, IN `Total` INT) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER INSERT INTO `User`…
I have a table employees as below: id name managerId 1 Annie Null 2 Bob Null 3 Chloe 1 4 Danny 2 5 Eddie 3 6 Felicia 3 7 Georgia 4 8 Harper 3 Top-level management is Annie and Bob…
I have 2 tables, referenced through a FK. users table (id as PK) cars table (id as PK, userId as FK to users, unique relationship id-userId) On a third table, I want to record some data from cars.but in case…