I am using pg_sym_decrypt/encrypt to decrypt/encrypt some of the fields in my table. Decryption happens on select in a separate EntityComputed view that has a o
I have a table with the following schema, id data_string 1 I have a pen. 2 Monday is not good. 3 I love Friday. ... ... And I also have a list of k
Would like to know why my query displays multiple entries per entity in the output. From what I understand there is only one active policy per entity. Created q
Thanks for reading my post. I wanna know, what is the difference between length (1-256) and (0-256) in sql and how to store them in database?. I was asked to de
I have a table and I want to increment a column by 1 when I insert a row into the same table. Table users - when I insert first row value of idusers is 1, and i
I wanted to select values from one table according to another table I have a booking system with 'user' information table and 'appointment table', they have col
Having the following table in SQL Server: create table [dbo].[stats]( [customerid] [int] NOT NULL, [username] [nvarchar](256) NOT NULL, [source] [in
I would like to know that is there any other effective way or query to get the desired output for the below query with AND operators because if I run this below
I want to convert value year month ('202101') 2021 > year 01 > month to 2021-01-31(end day) in toad for oracle please help me, if somebody know.
My SQL table contains two columns: Order and Order Line. Now I would like to add a third column (Status) to my table to indicate whether it's a single or multi
I have recently attended an interview on SQL. Below is the question: Write a query to retrieve city name, state name, city population and return the following c
I have found solution to my problem in one question Merge pandas dataframes where one value is between two others I tried to modify it for my situation but it d
The numbers in my results are of type integer, but I want to convert them to float. import sqlite3 connection = sqlite3.connect("mydatabase.db") my_cursor = con
I have grouped data in a temporary table according to id_card. There are multiple activities for each card. I want to send 1 email for all activities happened o
What I'm trying to do in this case is to get the ''most future'' record of a Bills table and get all the record prior 13 months from that last record, so what I
I have to calculate % contribution for each category. SELECT portfolio, (total_portfolio_views*1.00000/total_views)*100 view_contribution_perc FROM( select por
I have a dataset where certain operations occur during the overnight hours which I'd like to attribute to the day before. For example, anything happening betwee
I have the below 4 tables with relationship # sales # products +------------------+---------+ +------------------
I am trying to use COUNT with STRING_AGG. The problem is that in a subquery it counts as needed and I have count 1 when it's 1 employee that is taking the cours
loan_id coll_date coll_pay_mode 8007571771 APR-2022 CH 8007571771 FEB-2022 CH 8007571771 JAN-2022 CH 8007571771 MAR-2022 CH 8007571771 MAR-2022 CL 8007571771 M