I am working on a query that tries to count from an exact date to an exact date. Today is 2/16/2022. Between 6/30/2020 and 2/16/2022 19 months have gone by. My
for example I have created a dataframe in R named as "Numbers" which has following output: Numbers 1 2 3 2 4 1 When I tried to insert this dataframe in SQL tab
I've a Hana table having 220 million records. (Size 12GB). We currently use Informatica which performs a select * on my_table and exports a pipe separated data
Following SQL statement returns data when executed in Oracle SQL Developer: SELECT TC_GUID FROM TBLBUF WHERE TC_DEST = 'aaaaaaa' AND TC_STATE <= 20 but when
There is a notation field with different number of characters. Eg Exceed Limit Fee 26-January-2020 or Account Exceed Limit Fee 05-June-2001 I want to extract
Like the below trigger but I need to add update insert and delete all three. for update trigger columns dynamically getting is not able to code CREATE TRIGGER d
For example, In 'Monaco-Ville' the name is Monaco and the extension is -Ville. This problem is from SQLZOO. I am having trouble making my solution look like the
I am writing a query to be used as databases view, it looks now like this: SELECT contact.*, contact_users.names AS user_names, contact_status.status_
Here is the specification of my PostgreSQL. PostgreSQL 12.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit server_encod
I am having some difficulty building a file download statistics database and displaying the information how I would like. Table: customer_stat
I have an Oracle database from which I am selecting a table from a remote postgres database, pg. The column mydate is of type date. select to_char(mydate,'mm-d
I'm populating a table like so: ... time_id = uuid.uuid4() location_id = uuid.uuid4() id = row['id'] sql = ''' INSERT INTO "my-schema"."example"(
I've got a query which works in SQL :SELECT * FROM SOCIETY WHERE id NOT IN (SELECT society_id FROM activity) I'm trying to convert this into a DQL so I tried l
I'm looking for a way to speed up the following process: I have a SSIS package that loads data from Excel files on a weekly basis to SQL Server. There are 3 fi
We have a wordpress website that was migrated over a few months ago and some images are displaying the wrong link still. For example, one image on a gallery has
I am trying to partition the data from a Snowflake table and storing it as a parquet file in a S3 bucket. This partition allows me to store the data organised b
Sorry, I'm new to this. I read a few sources including some google documentation guides but still don't quiet understand: Every time GA4 streams data into bigqu
I have a requirement to translate it to an SQL script. I am using the information schema to get all the columns of a table and print their distinct count. I was
I'm using Entity Framework to call a stored procedure which takes 2 minutes to execute. As a result, I get a timeout exception. Is there any way I can use my
my query looks like but I am getting error select a.account_number,b.reference_acc from hdd.master_record format1 a join hdd.monetary b on a.load_date = b.load_