I need to create a Sales Report that shows all years sales per month, and cumulative sales. The database table is simple: I want the results to look similar to ExcelSheet below (I am showing only 2017/2018 amounts, but actual query needs to return results for all available years according to TransactionDate) …
APEX get Multiple entries FK
,i dont know what so search for my problem. I think its very simple, but i dont know about that 🙂 I have a Table where i listed all my “Groups/Teams” And then i have a Users Table where i list all the People: I use APEX 18.1 and have a Form with a List of Values, there i can
Snowflake SQL, how to lookahead until a certain occurrence of a value
Below is a sample of the text that I am working with. — info1: * val: “A” — Type: * answers: * – ! * val: “B” * – ! * val: “C” — info2: * val: “D” — …
Replace NULL values with values from join results
I have a table where the value of a column can be NULL because those records have been created in the past. But now I would like to update those records. The tables are as follows: TABLE 1 id | …
SQL – Select all rows and count only column greater than 1
Let’s say I have this table: name| value —-|—— A | 0 B | 0 A | 1 C | 1 A | 1 The select I want is to give the result like this: A | 2 B | 0 C | 1 In first phase I tried with: …
SQL query optimiser for (ISNULL(@parameter) OR @parameter > Column) patterns and whether it optimises for when @parameter is null
If I had a form where the user can specify a bunch of filters (e.g. productid > 5, category = “Applicances”, Price > 3), it seems natural to make a single prepared statement like: SELECT * FROM …
remove duplicate column name before add it on DataTable
Here is my code : private void executerRequete(string requete, string description, string niveauAlerte) { RequetesSQLResult res = new RequetesSQLResult(); res.Description = description; …
JSON_AGG as Object not Array – PostgresSQL
I have the table “mytable” with many “bad” and “good” records: |id|good|hour | |1 |t |12:00| |2 |f |12:00| |3 |t |13:00| |4 |t |13:00| |5 |t |13:00| |6 |f |14:00| …. My current query …
Assign number of quarter over years on SQL condition
I’m working on quarter counter that would be recognizing data gaps by quarter. Here is my data: Year Quarter Department 2017 1 A 2017 2 A 2017 3 A 2017 4 A 2018 …
Oracle SQL: How to select only ID‘s which are member in specific groups?
I want to select only those ID‘s which are in specific groups. For example: ID GroupID 1 11 1 12 2 11 2 12 2 13 Here I want to select the ID’s which are in the groups 11 and 12 but in no …