I am trying to use a postgreSQL INSERT query with a subquery as parameter value. This is to find the corresponding user_id from an accompanying auth_token in us
I have the following table that is comparing two similar tables: Source Part Info 1 Info 2 ... Info 12 Description Color Table 1 Wheel Circle ... Long Distanc
I'm creating a Python script to insert some records in a table, but have the following problem: INSERT INTO orders VALUES (7656940929251, "ADIDAS | KID'S STAN
I'm trying to get the row number of records in my database table, I'm using a variable and am executing the query, I get no errors, but get a null column for nu
Employee_table Id FirstName LastName Division 1 John Smith A 2 Emily Jones B 3 John Smith B 4 John Snow A 5 John Smith C I want to move all duplicate names fr
I have a table like this, id date start end product result 10 2022-06-10 2022-02-10 2022-06-12 183 TRUE
Using SQL I have | Message_From | Message_To |Message| Message_Time(Current TimeStamp)| | -------------| ------------|------ | -------------------------------|
I'm looking for a solution where the database schema and data are maintained in xml or in some file format, so that the db schema and the data
There is a mysql query, and I need to implement it in a postgresql query. create table objects( object_id int NOT NULL PRIMARY KEY , city_id int not null , p
I have this kind of date table: I want to find/detect all blank dates between them, or showing how many days it skipped. I tried: SELECT date FROM tbl_attenda
I am trying to insert a data frame row in a mysql table, but I have NA values in character and numeric columns. I'm getting this error: Error in .local(conn, st
When I passing parameters a1 as "a1", a2 as ["a21","a22"] @Query(value = "select * from a where if(:a1 !='', a1=:a1,1=1)" + "and if(:a2 !='',a2 in (
I have 2 tables with entries as: Transition table: From_Status_Id To_Status_Id PU_Id 5 1 868 5
SQL Noob here. I'm struggling with a (hopefully) simple SQL query and would appreciate if someone could help me understand if what I'm trying to do is even poss
I have one query result as: Wname NewCases Mon 2 Tues 1 Sat 3 Second query result as: Wname FollowUp Tues 3 Wed 4 Frid
I have data like this Id Revision_Id A_Id A_Name A_Info ================================================ 1 0 111 A1 A
I have a table like this I would like to select the Itemid that occurs more than once with a different Rate with group by Masterid The output should be somethi
I am working on an App connecting to the Snowflake database. I stumbled upon an issue while loading CSV files. I was using the NULL_IF condition in copy command
I have a .bat file that contains two commands: SQLCMD -S . -d "databaseName" -E -i "path_to_query1.sql" -y0 -s "|" -f o:65001 > outputPath1.json SQLCMD -S
we have an SP where the SP executes and returns multiple result set with change in column number as below: create proc test ab as select 1 as num1 select 1 as