I want to calculate which houses have more than a 10% difference (Qty column) between two different groups of items in the same column (Item).

I want to calculate which houses have more than a 10% difference (Qty column) between two different groups of items in the same column (Item).

Closed 4 days ago.

How can find the a string like ‘FD%’, ‘FD’, ‘FD with regardless of case sensitivity in oracle database objects source code like package spec, package body , table, view, Materialized view , procedure, function, trigger and etc

I need to extract information from a text field which can contain one of many values. The SQL looks like:

I am having a table with schema

the query should do this:
Run a query that shows the employee count per manager and the manager’s name. Using the same table.

I have a table with periods and values
I am trying to eliminate all pre-0 results when a 0 occurs in the table. I tried to apply some filters but failed

Wondering if anyone can assist with below SQL in Oracle. In my table, I have items setup at both WHs and DCs as 1-1 relations and my table looks like below.

Wondering if anyone can assist with below SQL in Oracle. In my table, I have items setup at both WHs and DCs as 1-1 relations and my table looks like below.