I want to return only the very first Process dated transaction for each User ID in this designated time-frame that was within 1 year of the purchase_date. From what we have: User ID Transaction …
SQL How Long Have Incomplete Records Been Outstanding Broken Down By Day
I have asked a similar question to this SQL Daily Outstanding Sales, Rolling Aggregate? however I now need to understand, by day, how long sales have been outstanding. This will be grouped into 24 …
Getting specific in an INNER JOIN mysqli select statement with group_concat
I have a table similar to below, I am trying to have a mysqli_query to get the movies that do not have the genre ‘Love’. create table movies (movieid int(1), title varchar(20), …
SQL Join Table on either matching row or all if second table is empty
I am new to SQL and need some assistance on a join between two tables in a stored procedure. The stored procedure takes as input multiple comma separated strings, one for each column the user wants to …
How to display an Image on my page from binary code on my
This is the first time I’m doing this. so I followed this tutorial: https://www.youtube.com/watch?v=YbiSrK4h1Kw and that’s the code in my ashx.cs file currently- using System; using System….
How do you write a Vertica SQL Statement to delete all entries that do not match a condition?
I need to delete all entries of an ID in a table where the day of a timestamp of an activity does not equal the day of a timestamp of the activity “item started”. This is what my table looks like: …
PL/SQL and SQL Developer different results from each other
I am executing a query in PL / SQL in version 7 and version 14, with a function created by me, and both bring me some results, the rest bring 0. However, when executing the same query in Oracle SQL …
SQL Combine two queries and SUM
Ok I am a little rusty in SQL. I have 2 exactly same tables with columns ID, Name, Gender, BG. BG is a internal reference. I can query each table individually: SELECT Gender,BG, COUNT(BG) CountValue …
latest timestamp with other variables being same
Hi I have a SQL table which has 6 columns, one of which is timestamp. I need to know how to retain only the row that has the most recent timestamp. example: Product|Price|Product_id|Stock_code|…
“Column name or number of supplied values does not match table definition” when trying to upload data to my DB
this is the C# code of the query (trying to make it so I can upload images to my DB table): protected void ButtonInsert_Click(object sender, EventArgs e) { insert(); } public …