I have a follow up question based on this answer which is string based: https://stackoverflow.com/a/41556608/221270 How to achieve the same conditional color and icon formatting but based on a value: If I use the code above I got this error: ORA-20999: Failed to parse SQL query! ORA-06550: line 10, column 1: …
Tag: sql
How to find days when workers don’t show up for work
I have a calender table for everyday in 2021. Also i have an entry table for workers everyday entries. It includes id and date columns. Calender just have date column. How can i find the days when the workers did not come? I thought searching days for every id would work Answer Left join the worker entries to…
How to increase performance when inserting more than 40k+ rows
My attempt: Currently, I am inserting a few records and it is giving exact results but in actuality, there are 40k+ records so I believe it will give performance issues also. Is there any way to insert the records faster because I will write a procedure for this insertion? Is there any other in which I can wr…
How to look for a specific thing within a table with postgres/nodejs
I’m currently using postgres, accessing it through a node server. I’m feeling stuck on how I would search for a specific term within a table in order to make a change. I know I can SELECT certain items, but I don’t know how to search within the items. say my table is: animal cuddly scary Med…
How can i unlock the Database in Go
Im a newbie in go and not the best in sql. I have a simple Table in my Database with the name of users. I store the SAM, First Name and Last Name in the table. When i now try to change something in the database, i get the error database is locked. Thats my code: decodeJSONBody and checkError work
Multi-column Index on a filter & sort by query
I am executing an query of type: Query: Table: entity also has an index (Btree) on it as such – Index: But it seems that this type of index is of no use on the above query. Can anyone suggest what kind of index would better serve this type of use-case? Some Additional Information – The Table is qu…
sql update – access to the current row
I would like update the column [ACIdent] from the table [Values]. With the subquery i try to get an ID from the same table. On the point ??? i try to access to the column [PathName] of the respective row of the update script. But this solution doesn’t work. How can i do this? Many thanks in advance! Ans…
Splitting strings in SQLite
Does anyone know how to split my address columns. I would like to divide it into three new columns, seperated by it’s commas. For example 1808 FOX CHASE DR, GOODLETTSVILLE, TN is divided into 1808 FOX CHASE DR GOODLETTSVILLE TN So far I’ve tried Although I cannot create the third column with the s…
How to select unique records from a 5 column table where the values can be the same but in different orders
I used 1 table to do a cross join 4 times giving me 5 columns of data. I used the same column in all 4 cross joins to get every combination. The only problem is I get the same data it is in a different order. I am trying to only get records that are unique. I can only have
How to update a date column based on proceeding order?
I have a table that contains three different status’ CLICKED > CLAIMED > BOUGHT (this is the correct order) (see table below for example) For each number_id, I need each of these status datetime to be in a separate COLUMN. In the last query, I need the query to have the LAST status based on the up…