I am trying to add everything in te data (dollar_value_us, QUANTITY) but not add shipping total since each transaction number has multiple items but the customer only paid shipping once. I am using …
PHP why doesn’t my filtering works as it should be
So, I have to do a web store, where a person can filter the products. I have added the button [pod 300€] and [vsi izdelki]. But now when I click on button [pod 300€] it shows the products which are …
oracle trigger and json_value
Hi I want to store some values from :new.payload via an trigger. this works in sql-developer but not in a trigger… select json_value(‘{“timestamp”:”2019-05-09T14:00:00Z”,”value”:0,”unit”:”W/m²”}’, …
How to force extenal library to use SQL transaction
I have an external library to which I pass an instance of System.Data.SqlClient.SqlConnection and I want to wrap everything that library does on that connection in a transaction. When I was working …
MySQL Select works fine but Delete hangs indefinitely based on the position of GROUP BY
select * from table1 where ID in ( select min(a.ID) from (select * from table1) a group by id_x, id_y, col_z having count(*) > 1) Above query ran in 2.2 seconds returning four result. Now when …
Error: No matching signature for function IF for argument types: BOOL. Supported signature: IF(BOOL, ANY, ANY)
I’m trying to count the number of times a “rating” is above 9. Working in Google BigQuery with StandardSQL I previously was using a CASE WHEN function but wanted to change it to an IF as there is …
How to get Average Salary of SQL HourlyPayRate Column?
I am working on creating a SSRS report and I want to get the Average of the HourlyPayRate Column that I have(in my case statement). I am a self learner of SQL and was wondering how I can get the AVG …
Get number of records with SQL while using LIMIT and OFFSET
I’m trying to implement pages into my webpage. I have got it so that a user can put the page number they want into the url bar that they want to go to. I did this by using that number in the URL bar …
Inserting image to BYTES column – type “binary” does not exist
I’m trying to insert an image from Spring’s MultipartFile field into Postgres’ BYTEA column with jOOQ but I keep getting confusing error message. What does it mean and how the insert should be done? …
Subquery is slow
I have a mysql table with about 10 Million rows. For each row, I have an id column and date column. The id column is not unique, and for one id there are multiple rows with different values for date, …