I have the following code for a login winform. When I make the connection to the database and make a select statement I get no rows back. I’m getting the message “No data exists for the row/column.” …
Very slow query when using CONNECT BY LEVEL
NEEDS I want to create a table like the following in Oracle SQL: COUNTRY NAME WMWHSE_ID DATE US CRD2 1 040620 GR WAZ 2 040620 CN KOL 3 040620 …
PostgreSQL: Make data appear in different rows instead of same row
I have this query: SELECT SUM(CASE WHEN color = ‘blue’ THEN 1 ELSE 0 END) AS “Blue”, SUM(CASE WHEN color = ‘purple’ THEN 1 ELSE 0 END) AS “Purple”, SUM(CASE WHEN color = ‘yellow’ THEN 1 …
SQL – Where clause with case statement and wildcards
I’m working in Oracle’s APEX environment, trying to return all values in one case and specific values in another case. If you aren’t familiar with APEX, it uses low-code to produce a front-end page …
Include indicator of data present, but not include in results
I can’t quite explain it properly, hence the awful title. As an example, I would have a query that shows customer complaints, of a certain type, and the dates since those complaints. Something like …
How to do a SQL query with SRFs and display only distinct values?
I’m trying to think about a way to do a query with a single row function and display only distinct values. Lets suppose that I have a table employees with the columns employee, store and salary and I …
ERROR 1054 (42S22): Unknown column ‘pc.project_id’ in ‘on clause’ even when column project_id exists
I am trying to get a sum from my DB with a query written in hibernate @Query(value = “SELECT COALESCE(sum(charge),0) FROM initial_charge I INNER JOIN task T ON T.id = I.task_id ” +” …
SQL: Is there a way to capture “once every 45 days”?
First time post, but I’ve stumbled across Stackoverflow for years. A patient might get a particular lab test many many times in a span of a few months. However, to reduce duplication, I only want to …
Select only certain rows from a where in query in SQL
I have a query trying to get duplicates from a table of user invites. I can get the duplicates through a “WHERE IN” clause and filter that list to be duplicates where at least one of the duplicates …
ORA-00933 in ODI procedure
I’m mapping two table in ODI and I have a problem. i’ve mapped the source table to the target table (called DM_BUSINESS with the columns BUSINESS_ID, NAME, ADDRESS). After that I’ve created a …