I am attempting to display a table from my Azure SQL database on a webpage. I have been looking around and can't seem to figure out why this isn't working This
So, say i have a record in database like "Something with corn". if i use sql like "SELECT * FROM table WHERE column LIKE '%Something corn%'", the record wont sh
Just found the speed for importing sorted csv file is faster than the speed for importing unsorted csv file in TDengine database, each csv file has 1000000 rows
I am considering switching to PostgreSQL, because of the JSON support. However, I am wondering, if the following would be possible with a single query: Let's s
I am new to postgres, probably missing something silly like (the correct name of my directory). Can someone guide me? I am following book instructions, Practica
Here is sample data I am looking for total buying trade value and total selling trades value based on country. Here are two tables, country, and trades Table [c
I'm new into postgresSQL, in my course in "Advance database" we are given a problem to simulate a crash at given location in postgres, is anyone got an idea how
I want to merge two tables and subtract the number of orders in resulting table from left join from the resulting table in inner join. This is what I have done
I have a data that combines inventory, sales forecast, and future supply data for different parts. I have combined it to give me a table that gives a net quanti
I have an issue where I kind of know what it is but do not know the solution to it. When I fetch data from an external Snowflake DB, it limits the size of the d
I wish to build a sql2 jcr query to find all pages under /content that contains this component, e.g /apps/platform/aem-core/components/content/form/form I read
id1 id2 v1 v2 v3 P1 I1 A B C P1 I2 D E F P2 I1 A B D P3 I1 A D E P2 I2 B D E How can I get from the table above to following: First, I need all entries with a
So I'm trying to exclude a bunch of different entries with specific words from my query and I was wondering if there was a more efficient/faster way of doing th
I'm trying to create a query with a variable number of parameters, giving to the program the name of the table and an Array for the names of parameters and anot
I'm attempting to learn SQL and currently doing the guest house questions found on sqlzoo. I'm stuck on Question 13 and can't seem to figure it out how to fix i
I need help with writing the query that will say month difference between return and purchase dates, see the example below. Product PurchaseDate (dd/mm/yy) Ret
I have a Flask server Running on Azure provided by Azure App services with sqlite3 as a database. I am unable to update sqlite3 as it is showing that database i
How do I use a parameter multiple times in the same query? Here is my Query: @Query(value = """ SELECT * FROM person WHERE first_name = ? or last_name =
I have 2 database tables Customer and Items with 1 -> many relation. To fetch data from database i am using the following query. select customer.id, cust
I am using oracle DB. I have a Aggregated script. We found that some of the rows in the table are repeated, unwanted and hence, is not supposed to be added in