can someone help me with the next issue. I have words database and I need to check availability of the next letters for substring in the middle of word. For example I have few words which have ‘gr’ in …
Tag: sql
How to update two columns with same name from two tables in a join query
I am getting an error: Property or Indexer cannot be assigned to “–” it is read only when trying to update two columns with the same name in two tables in a join query. How do I get this to work? …
SQL Query joins tables and returns all records with dynamic id
I have two tables: staffs and teams. Here are their properties: # Staffs Table id | name 1 | john 2 | bob 3 | alex 4 | george # Teams Table id | name | supervisor_id 1 | a-team 1 …
ORA-00945: specified clustered column does not exist
here’s the code with the cluster included, the table never gets created and oracle documentation is ass create cluster c123 (a integer) size 512; / drop table t123; / create table t123 cluster c123 …
Need Help Extracting Values from URL Link in SQLite
I am using DB Browser for SQLite. I have a table called ‘df’ and a column with a bunch of URL links called ‘links’. All the links are from the same website and follow the same structured format: …
A function that returns different column values based on input
Here is a table FRUITS – FILTER A B C Apple 0 3 6 Orange 1 4 7 Apricot 2 5 8 Is it possible to create a function that returns column A for apple (0), B for Orange(4) and C for …
Is there a way to write an insert statement with string_split which ignores duplicates?
I am trying to insert rows into a table using string_split command. It works fine if there are no duplicates. However, if there are duplicates, it errors out. I would like to know how to modify the …
Join query with null values
I have this query SELECT * FROM orders, products, suppliers WHERE product_id=products.id AND `geleverd` = 1 AND supplier_id=suppliers.id It works fine except that when the suppliers_id is …
Find which array an item is in given multiple arrays and item only exists in one in PHP/SQL
I have an ecommerce website and I have it set up that countries are split into different zones for shipping costs. I have 8 zones, these are all arrays of country codes, there can be no duplicates in …
How to separate values with Parse name in SQL Server
I have a value (500 , 850 , 65.5) as GivenUnitPrice and I want to separate these by making separate columns by PARSENAME I have tried like this and the result is Answer Seems you want to seperate the characters by commas but Parsename() function splits by dot character( e.g. decimal number 65.5 is also splitt…