Skip to content

Tag: oracle-apex

Column merge using sum in case Oracle APEX

I need help How can I merge the column into a single column, here is my code, is this method is correct. I want to get the count of the selected row in the table for the columns. Can you guys help me I’m a beginner at SQL. Thank you in advance Answer If you want just one row in

SQL query for descending order by sum of values

I have an Apex Oracle app to do. This is the app description: A touristic destination is defined by its name and description. Each touristic destination has a number of bookings, defined by start date, end date, description, price as in the following example: Touristic destination: Hotel Sunrise, Hawaii Start…