This is only my second time using Stack Overflow so I’m open to any constructive criticism on how to better format my questions. I have a list of orders and I’m wanting to create a table of useful customer information. I’ve created a new table that identifies unique customers (using just a select distinct of customer IDs) but I’m not
Convert column to row and sum query in different table
i trying to figure to convert sumtchtraffic and totalpayloadGb column in sitetable and sum data totalpayloadGb & sumtchtraffic where BTS_TYPE 2g, 3g and 4g in techtable i tried like this, but i …
Asking for help on correct way to us SQL with CTE to create JSON_OBJECT
The requested JSON needs to be in this form: { “header”: { “InstanceName”: “US” }, “erpReferenceData”: { “erpReferences”: […
Regular expression in mysql to answer the given query
my mysql table has a column structure that dumps various attributes which is separated by “;” for each of the element of a html file. +———–+————————————+ | …
Oracle SQL Developer dynamic date table name
I’m hoping to dynamically reference last Fridays date in the weekly sales tables in Oracle SQL Developer i.e. SELECT * FROM Sales_DDMMYY I can do this in SQL Server (DECLARE / SET / EXECUTE) but haven’…
SQL Server INNER JOIN and GROUP BY
In sql server I’m trying to group by each sales people some infos as follow: I have 2 tables: Positions and Clients In Positions table, I have the following columns: Client_Id, Balance, Acquisition_Cost and in the Clients table I use the following columns: Client_Id and Sales_person. I want to group by Sales_person (Clients table) the Client_id, Balance, Acquisition_Cost (Positions table)
Extracting text between a character and space
I have this text and I want to extract the id of collector that is bolded knowing that the id is not fixed it May 5 digits or even three digits EX: what is the best approach to do that by oracle functions Answer I think you need REGEXP_SUBSTR as follows:
Oracle APEX Custom Login Authentication
I have been following this tutorial : https://www.youtube.com/watch?v=ngOm5uBP1uE&feature=emb_title. I followed all the codes with my needed variables and they are as follows : -Creating Table …
Query with empty or one row only
I’m using an oracle DB and I need to know if certain value is on myTable (it can be 0-N times), but i’m using a software that does some tasks with each row of the query output, so, my result should be empty when I have no value in myTable (so the software will do nothing) or one row when
PostgreSQL ltree find all child node of a given path (With out using expression)
Only child node of given path (Except the given path) Query: select path from tree where path <@ 'a.b.c'; Result: Expected result: All the below node of a.b.c (In result don't needed a.b.c)