Hi All trying to figure out a way to transpose data in columns dynamically. In the data the distinct number of Traits will increase/decrease. I know I can hardc
I have these two SQL tables: Bills (BillId, Folio, Date, ProductId) BillsRows (BillRowId, BillId, ProductId, Lot, Quantity, Price) ProductId is optional in Bil
UPDATE tb FROM Table1 tb, ( SELECT oreplace(data, '.', '') AS data FROM Table2 ) tb2 SET column = 'Y' WHERE tb.column1
I am running into an issue where my .net application (C#) will not connect to SQL Server when ran by a domain user. Exception is: The underlying provider faile
I am doing a TODO list app and I'm trying to delete a list and every task which has the referencing listID.The problem is that on delete casca
I'm new to hiveSQL and I'm trying to extract a value from the column col_a from the data df which is in this format: \\\"id\\\":\\\"101_12345\\\" I only need to
I have a many to many relationship between User and Category through UserCategory as below. let user = await User.findAll({ where: { id: req.query.user
I'm using Postgres version 9.6.9 and attempting to use width_bucket() to generate a histogram with buckets consisting of equal widths. However, the query I'm us
I am trying to figure out how to extract customer ID from string that looks loke this: {"param":"success","value":"10","level":"0","error_code":"101","customer
I have 2 tables orders and product as orders has only one field (order_id) and the products have a reference to the order_id, how to get the name of product wit
I have 2 grids and 2 tables. I want the second one to display elements that are related to the selected enement of first grid. This can probably be done in 2 wa
I have a query with a few columns. I need to find the avg of a particular column and then use the average value to calculate other values. I am finding avg with
I have these 2 tables tasks and subtasks with these columns: Tasks id name description Subtasks id name description task_id I'm trying to do a query that would
Background: I need to create a web application that connects to an Oracle database hosted by my university through a VPN. The app does not have to be hosted onl
I have one table that contains two columns: id (integer) list_colum (longtext) - contains json array (e.g. [1, 2, 3]) I want to select all records that have an
I'm trying out statements for creating a database, and after 10 entities without any issues I ran into this error Error: Near line 83: near "Transaction":
I have a comments column and the comments added to release are stored as rich text in comments column. Now i'm trying to process this data and get an human read
I am defining a new WITH statement as newStaff, and then I am taking that data and filling it into other tables. It doesn't seem to let me ref
I am running one SQL query in Hive and it gives different results with CBO enabled and disabled. The results are wrong when CBO is enabled (set hive.cbo.enable=
I am doing an outer join between two market data tables. The two tables have trading volume reported differently, therefor I need to query them separately and t