I have a request to identify records between two shifts. Shift 1 begin at 7am – 6:59pm same day and shift 2 begin on 7pm – 6:59am the next day. I can only write SQL cannot create function or procedure. Could you please advice how I can go about accomplish this through SQL code. sample data

I am trying to write a SQL that retrieves parent-child relationships from the product data, including a calculated Consolidated Quantity. The consolidated quantity is derived by multiplying the child’s quantity by the parent’s quantity recursively, considering multiple levels of hierarchy.

I am trying to write a SQL that retrieves parent-child relationships from the product data, including a calculated Consolidated Quantity. The consolidated quantity is derived by multiplying the child’s quantity by the parent’s quantity recursively, considering multiple levels of hierarchy.

I have a very slow query, not sure how to fix this

I’m working on updating a large SQL database and need to manage dynamic exclusions specified in a comma-separated list within the exclude_fkidval column. Below is the structure of the table before applying the SQL update.

I’m encountering some issues with hierarchical structure query in Oracle. Specifically, I’m trying to build a query to represent a hierarchical structure, but the results are not as expected. Here are the details: I created a table in my Oracle database as:

Hi The table details looks like :
Table name: TBL_TXN

I have the below SQL in Oracle DB that I am expecting would return March 1st, 2024 (01-MAR-24) however it is instead returning 01-AUG-24

I developed this query in SQL Developer:

I have this SQL code that runs product sales information, however I would like it to display a set range of numbers. The ALU is my product numbers, I have a large range of numbers and would only like to see ALU numbers between 4000000 and 4009999. Here is my current code. I have selected some results to be ignored.
Any help in the right direction would be great.