Current record: When I update the value of current record's activity_weightage as 2 it should pick up start_date as current_date and end_date as 31/12/2099. and it should update the original record's end date with today's date. How to write SQL…
Suppose I have a string in my table, I now want to remove all characters that are the same as the first character (case-insensitive) from that string. For example: uJnMus onsyk uyT Uaszs -> JnMs onsyk yT aszs @uJnMus o@nsyk…
I'm working on analyzing some data. I have a way of doing this in excel, but it's slow and too much manual work. I'd like to find a more effective way to find what I'm looking for. Here's the scenario:…
I have the following table: create table sales (id,transaction_ref,type,amount,je_id) as values (1,'a','invoice',100,null) ,(2,'b','invoice',200,null) ,(3,'c','invoice',300,null) ,(4,'d','invoice',400,null) ,(5,'a','entry',10,null) ,(6,'b','entry',20,null) ,(7,'c','entry',30,null) ,(8,'d','entry',40,null); I want to match the records on the basis of transaction_ref and then update the ids of entry type records in…
I want to display the count of hosts/servers that do not have a given package installed (example: "abc") in a Grafana dashboard with Postgres as data source. Example table of a single server with "abc" package present which is displayed…
It appears that with non Azure SQL DBs you can right click the DB and then go to 'Tasks' to be able to script out your views. I don't have that option with my Azure SQL. I can always script…
There are two tables. table1 select tt1.* from (values(1,'key1',5),(2,'key1',6),(3,'key1',7) ) as tt1(id, field2,field3) table2 select tt2.* from (values(4,'key1',null),(2,'key1',null),(3,'key1',null)) as tt2(id, field2,field3) How can I combine these two tables in a query to get the result like this? select tt2.* from…
I am trying to create a query for my website to get the total number of active users for a selected time period and for a specific user account ID to filter for teams. My current query works but without…
I have SQL that gets the past 60 days and the sum of view for each of these days and all works fine. I'm trying to take these past 60 days and get the same days view counts from the…
I am creating a table in Postgresql, this DDL is the result of a script that I am making to compare bancos. CREATE TABLE projeto_modelo.exemplo_fk1 ( id SERIAL NOT NULL, nome varchar(30) NOT NULL, criado_em timestamp NOT NULL, id_exmp_fk2 int4…