I have a json formatted like: myjson = {"key":["value1","value2"]} and a I want to convert it as string Sometime this json can return null: myjson = {"key":null} . I want to get the values as a string, but I get…
EDIT I misread my initial error and blamed the INDEX not being used on the wrong columns. I was able to recreate the issue that I saw and the solution that ysth suggested worked. Below are the create tables statements,…
I find it difficult to fill a new column that I just added to an already existing table in SQL I tried the Insert command, to fill in the table afresh, but couldn't see it true because the table has…
There is a table like this, how can I get customer_id, amount_spent, top_item out of it? amount_spent the amount spent on all items by this customer top_item, which displays the name of the item for which the customer has spent…
I'm pulling from a database which has multiple records for the same id, and I need to pull it all into the same table output: ID Type Value Value2 1 Age 10 1 Height 136 1 Name Jeff 2 Age…
This is my parent table acc_detial - ACC_DETIAL example - acc_id 1 2 3 Now i have 3 tables: ORDER EMAIL REPORT Each table contains 100 rows and acc_id are ForeignKey from ACC_DETIAL. In ORDER table I have a columns…
I have a reports table which looks like something as follows: Reports is monthly reports of users putting their efforts. It's many to many relationship table. id user_id project_id total_effort created_at 1 5 232 40 2023-01-23 I want to get…
I have a table with codes for multilingual commands with a structure like this: id code lang text 1 exit_command de Fenster Schliessen 2 exit_command en Close window .... (The column lang also contains other languages such as Italian, Japanese,…
My task is to create a function that concatenates the first name and last name from two fields found on the same table. Table "cust": cus_id f_name l_name email 1 Jack Daniels [email protected] 2 Jose Quervo [email protected] 5 Jim Beam…
I am currently studying SQL and I am still a newbie. I have this task where I need to split some rows with various entries like dates and user IDs. I really need help +-------+------------------------------+---------------------------+ | TYPE | DATES |…