Table looks like this: id Product Price price_update_date 1 Product 21.99 2022-11-09 6:32:11 2 Product 22.99 2022-09-27 9:06:14 3 Product 19.99 2022-07-10 6:27:49 4 Product 18.99 2022-05-24 7:31:20 5 Product 17.98 2022-04-21 8:59:18 6 Product 17.99 2022-02-02 8:33:48 7 Product…
I'm trying to generate the Fibonacci sequence with a function in SQL. It takes an input parameter pstop integer (10 by default) and returns a table with all Fibonacci numbers less than pstop. But the output starts with these numbers…
I have a JSON type SQL column in SQL table as below example. I want the below code to be converted into separate columns such as drugs as table name and other attribute as column name, how can I use…
I'm oversimplifying my problem a bit. I have a table with the following format: id parent_id name 1 [null] id1 2 1 id2 3 2 aa3 4 3 bb4 5 2 abc 6 [null] abc1 I want to retrieve, in…
Supposing I have something like Name username Mike BestMike99 Someone DaBest What query do I need to run in order to SELECT/return a json like json_agg {Mike: BestMike99, Someone: Dabest}
Here I have pizza table pizza_id toppings 1 1,2,3,4,5,6,8,10 2 4,6,7,9,11,12 I would like to know toppings with each pizza_id in common. Most used toppings in both the pizza_id..., expected answer as below table Pizza_id toppings 1 4,6 2 4,6…
I am new to Postgresql (v.13). I have 50 tables into a "ign" schema (schema other than public). I would like for each of these 50 tables: Add a prefix to the name of the table: "IGN_bdTopo_" Add a suffix…
I have two tables info and sell_info. info table contains "list of record" and sell_info contains "product which are on sale". I want to get "lowest" value of record where id = 1. How can i do this? Here is…
I have the following table and i am supposed to count the entries(5,4,3,2,1) per column name ID ClientID Responsiveness1 Responsiveness2 Reliability1 1024 3511 5 4 3 1025 4571 5 3 5 1026 3827 4 5 4 1027 7652 1 1…
here i need an help like how to optimize this union all query the table has index for where clause column but it's not picking it up and i even tried with force index none of that works any better…