I need to write a sql statement(Oracle) where I can withdraw data from two diff tables and check for a condition and return a certain string. My statement goes like this, When I run this I get a error: “FROM keyword not found where expected”and points to the c in line 2. and if I change the from t…
Tag: select
SQL: Update a table column with data in column retrieved from a view in same procedure
I’m trying to do a select and update within the same local procedure. The idea is to retrieve the number of ordered products from a specific order in the view (Produktantal) and then updating the stock numbers (antal) from the table “produktlager” with the data retrieved from the view. IR…
SQL Select after character /
I’d like to select everything AFTER a certain character (/) that is placed on the most right side. I’v in CSV_COL(3) this text 200/100 or 50/10 ot 10/5 etc.. and i need to uso only number to the …
MySQL – Select on varchar column with 0 (zero) as criteria returns all rows?
Sorry in advance – this seems like a really dumb question. But… If I run a select query on a varchar() column, but use zero for the column value in the where clause – why does it return all rows? …
MySQL One row for each hour 00:01:00 and 23:59:00 interval of the day
I’m trying to get one row for each hour of the day, which I intent to left join certain data to. I need selected the 00:01:00 and 23:59:00 interval hour for each day. I have tried this solution but I can’t selected 00:01:00 and 23:59:00 interval hour but only 00:00:00 and 23:00:00 interval hour. H…
SQL statement HOW to count all relevant rows (A,B) and (B,A) together
I am trying to count all rows where seller and buyer has also an inverted relationship. So the buyer sells to seller. I do not have any clue to group them together. Table T1| ———————- …
Conditional Query Using “AS” field
Above you can see my code. It is currently returning exactly the output I want when you remove the “WHERE” function. I’m adding the “WHERE” function and attempting to access the new column I made called “NPO”. It seems as if the column does not exist to the SQL editor…
Mysql Left join index
I used the following query To display items from two tables, where the id of the first table is the item_id of the second. My question is , when I try to display this in php , if I want to display a.id i can try with: or since both tables have id,on the first example displays only if there
Multiple SUM in one query with multiple where
I’m trying to write a SQL query that produces a table with summarized values for each year and month. I have a table that looks something like this: And another table that looks like this: I want to have a query that returns the sum for each month like this: Explanation of the output: Year and Month are…
How to use aggregate functions in SQL Server
I have a situation where I have a Customer table and I need to locate document numbers from a column which is structured as a string where the first 4 characters represent the type of document (e.g.,’…