I’m trying to make a trigger that updates the ID_ABONAMENT from the CONTRACTE table, when the ABONATI table is updated. The problem is that the trigger is not called when I update a row in the ABONATI …
How to exclude rows with similar columns?
There is a table: | date | action | issue_id | | 2020-12-14 | close | 1 | | 2020-12-15 | close | 1 | | 2020-12-16 | close | 1 | | 2020-12-14 | close | 2 | …
Select sqlite android
I have a query with a condition but it is returning an empty result even though I have the data that matches these conditions. I am a beginner, so I’m not sure if this query is correct. public Cursor …
Finding the length of years between todays date and a column of dates
I’m new to sql so it might not be too difficult for some of you but I simply need to find the length in years between a column displaying different dates and todays date. I’m not too sure what i’m …
Case statement help for replacing null from multiple joins
so i have the following case below where if jl name does not have n/a i want it to come from the same column. if there is n/a i want to look into this subquery and find the recent jl name. but if the …
AWS Athena custom data format?
I’d like to query my app logs on S3 with AWS Athena but I’m having trouble creating the table/specifying the data format. This is how the log lines look: 2020-12-09T18:08:48.789Z {“reqid”:&…
What is the use of ROLES in Azure Syanpse if I cannot add any USER to it?
I am creating users, in particular, login_id in Azure synapse using Admin login id and password. As of now, I have to give permission individually to every login using the code below. (brown_batman is …
Find common values in many tables
I have 5 tables and I want to find the common values between them in one column. The column name differs in two tables(account_number, account,account_id). select * from db.table1 as a INNER JOIN db….
Is it possible to sum up time field in SQL Server?
I have 3 time(0) column in 1 row. I want to calculate arrival-Time column automatically and this is result of the sum of Departure-Time + Duration is it possible with trigger or computed area method? thanks in advance Answer SQL Server does not support direct addition on time values; however, you can use datediff against 0 to find how many
How to select an element just once in plain SQL
I’ve seen other similar questions to mine, but I haven’t found one that could actually help me. I have a table, defined like so: CREATE TABLE “DOWNLOAD_HISTORY” ( “ID” …