Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
With sales_data as ( Select fs.store_id, fs.prod_id , fs.zone_id,sum(qty_sold) qty_sold, dense_rank() over (order by max(qty_sold) desc ) rk from fact_sales fs INNER JOIN DIM_PROD dp on (dp.prod_id=fs.prod_id) where to_Char(fs.sale_date,'MON-YYYY') <= to_char(to_date('&1','YYYYMMDD'),'MON-YYYY') and dp.prod_name='&2' group by fs.store_id, fs.prod_id , fs.zone_id ) Select dp.prod_name, ds.store_name , dz.zone_code , sd.qty_sold * dp.Unit_Price_Rs HIGHEST_SALE ,(dp.Unit_Price_Rs * (sd.qty_sold * dp.Unit_Price_Rs)) Total_Unit_Price_Rs from sales_data sd JOIN DIM_STORES ds on (ds.store_id=sd.store_id and ds.zone_id=sd.zone_id) JOIN DIM_ZONE dz on (dz.zone_id=ds.zone_id) JOIN DIM_PROD dp on (dp.prod_id=sd.prod_id) where rk=1;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to convert a blob into string. I have a command but it gives only some part of text from blob||2||52|
|Creation date for a PDB||5||80|
|In the GetNet statement, I have an error saying, "Operator '*' cannot be applied to operands to type 'decimal' and 'double'.||1||96|
|PL/SQl Expanding the WHERE statement in query||3||54|
Join the community of 500,000 technology professionals and ask your questions.