Say you want to optimize a query in a postgres database like: SELECT DISTINCT ON (first) first, second, third FROM my_table WHERE second > 100 AND fourth = 3 ORDER BY first, second DESC, third DESC (EDIT: In this example,…
I have tables level_one_table, level_two_table, and level_three_table. level_one_table to level_two_table: one to multiple rows level_two_table to level_three_table: one to one row Goal: select them all and level_two_table rows able to use LIMIT and ORDER BY. Return data structure like below:…
My issue is that we use Debezium to monitor the DB events and even when the is a simple update of the data present in the plugin table, the OCS inventory source code performs a delete and an insert operation…
Here is my code: SELECT * FROM OPENJSON ('{"AFN":{"code":"AFN","name":"Afghan Afghani","decimal_digits":0,"name_plural":"Afghan Afghanis","rounding":0,"symbol":"Af","symbol_native":"؋"},"ALL":{"code":"ALL","name":"Albanian Lek","decimal_digits":0,"name_plural":"Albanian lekë","rounding":0,"symbol":"ALL","symbol_native":"Lek"},"AMD":{"code":"AMD","name":"Armenian Dram","decimal_digits":0,"name_plural":"Armenian drams","rounding":0,"symbol":"AMD","symbol_native":"դր."},"ANG":{"code":"ANG","name":"NL Antillean Guilder","decimal_digits":2,"name_plural":"NL Antillean Guilders","rounding":0,"symbol":"ƒ","symbol_native":"NAƒ"},"AOA":{"code":"AOA","name":"Angolan Kwanza","decimal_digits":2,"name_plural":"Angolan Kwanza","rounding":0,"symbol":"Kz","symbol_native":"Kz"},"ARS":{"code":"ARS","name":"Argentine Peso","decimal_digits":2,"name_plural":"Argentine pesos","rounding":0,"symbol":"AR$","symbol_native":"$"},"AUD":{"code":"AUD","name":"Australian Dollar","decimal_digits":2,"name_plural":"Australian dollars","rounding":0,"symbol":"AU$","symbol_native":"$"},"AWG":{"code":"AWG","name":"Aruban Florin","decimal_digits":2,"name_plural":"Aruban Florin","rounding":0,"symbol":"Afl.","symbol_native":"Afl."},"AZN":{"code":"AZN","name":"Azerbaijani Manat","decimal_digits":2,"name_plural":"Azerbaijani manats","rounding":0,"symbol":"man.","symbol_native":"ман."},"BAM":{"code":"BAM","name":"Bosnia-Herzegovina Convertible Mark","decimal_digits":2,"name_plural":"Bosnia-Herzegovina convertible marks","rounding":0,"symbol":"KM","symbol_native":"KM"},"BBD":{"code":"BBD","name":"Barbadian Dollar","decimal_digits":2,"name_plural":"Barbadian Dollars","rounding":0,"symbol":"Bds$","symbol_native":"$"},"BDT":{"code":"BDT","name":"Bangladeshi Taka","decimal_digits":2,"name_plural":"Bangladeshi takas","rounding":0,"symbol":"Tk","symbol_native":"৳"},"BGN":{"code":"BGN","name":"Bulgarian Lev","decimal_digits":2,"name_plural":"Bulgarian leva","rounding":0,"symbol":"BGN","symbol_native":"лв."},"BHD":{"code":"BHD","name":"Bahraini Dinar","decimal_digits":3,"name_plural":"Bahraini…
I added a JSON column to a table in MySql that holds a small amount of data (~about 7Kb) for each row. The table has roughly 135K rows. Prior to this addition, all my queries on this table executed in…
I'm relatively early in SQL learning. I have made some data which has records where the date is missing. I want to capture as an output records that show the missing dates and the associated department name affected. output of…
I have simple table as shown below, datetime Rupee Pound 2019-02-16 80% 70% 2019-02-17 30% 60% 2019-02-18 67% 89% And MySQL query looks like below, SELECT json_arrayagg(obj) FROM ( SELECT json_object( 'currency', 'rupee', 'data', json_arrayagg(json_array(datetime, rupee)) ) AS obj FROM…
I have a table like this: ----------------- id | date ----------------- 1 | 2023-10-07 2 | 2023-10-08 3 | 2023-10-14 and I want to get the record count up to the current record where the date is less than Sunday…
I have a DB with two tables: employees table: fields = {ID, name} turnShift table: fields = {ID, date, ID_employee1, ID_employee2} Here is an example of this DB. Using MYSQL, I'd like to execute a SELECT query able to show…
Let's say I have 3 DB tables in MySQL: t1 t2 t3 And each of them has the same columns I am interested in. And also each of them has some other columns that I am not interested in. Now,…