Tag: oracle

My requirement is to display country name, total number of invoices and their average amount. Moreover, I need to return only those countries where the average invoice amount is greater than the average invoice amount of all invoices. Query for Oracle Database Result: Austria 1 9500 Expected: Austria 2 4825 S…

I have date range eg. ‘2021-01-05’ and ‘2021-02-10’. Two months January and February. Need resaults: Answer You want to iterate through the months. This is done with a recursive query in SQL:

I have these two tables: Table imp_source: Table imp_update: I need to write a query to have this result: All values of imp_update The values of imp_source when there is no update for seq column of a product/class combination. Update 1: As you can see, the row in imp_source is not in result Because in imp_upd…

I have this table (with order by product, seq): As you can see because of some delete statments I need to reset the seq column and have a seq from 1 for every product/group like this: I tried to create a new counter with this code: and the result was like this: But when I try it with Update I

I have a data which is represented as below: I have a query as follows which has to be tweaked to get parent and child names respectively My output should look as follows: I basically want to split the lk.name based on seperator (,) and 1st string before seperator is parentName and 2nd string after seperator …