I need your help. I want to create a script to update the flag to 'X' where flag is 'No' and get the first 3 rownum of unique Id. E.g. tablename: TBL_INFO Sample table: ------------------------- ID | FLAG ------------------------- 123…
I'd like to understand why the following 2 queries that select duplicates from the companies table have different execution times. The second query with the JOIN is executed much faster. The query is executed on: a companies table with ~200k…
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`…