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 …
Tag: sql
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 …
Carriage Return in Table Header
I’m writing an Excel macro to pull in data from another Workbook. I don’t have any control over that workbook, which is a shame because then I could fix this issue at source, as it is i have to work …
Transform table to one-hot encoding for many rows
I have a SQL table of the following format: ID Cat 1 A 1 B 1 D 1 F 2 B 2 C 2 D 3 A 3 F Now, I want to create a table with one ID per row, and multiple Cat’s in a row. My …
SQL request with GROUP BY and SUM in Eloquent
I just want make a simple sql request in my laravel application. I’m not very comfortable with Eloquent aha. This is the SQL request I want to make with eloquent : select user_id, project_id, sum(…
Response from query couldn’t map to pojo class spring boot
Every response from query should be mapped to a poja class. I have written a native query @Query(value=”SELECT new QuestionJsonTotalAnswer(q.question) FROM mydb.question q”, nativeQuery=true) List&…