var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sqlplus queries problem.... [urgent]
hi i'm new to SQL plus queries statement and i have the foloowing query that doesnt seems to work well...
SELECT C.CUST_ID, P.SERVICE_TOTAL, O.ORDER_TOTAL, E.SERVICE_NUMBER, E.SERVICE_DESC
FROM CUSTOMER C, PAYMENT P, ORDERS O, EXTENDED_SERVICE E, RESERVATION R, CHECK_IN I, ORDER_LINE N, MEMBERSHIP M
error occur when i try to use 'HAVING ORDER>50.00"...... CAN ANYBODY KNOW HOW TO SOLVE THIS PROBLEM ??
Did you try
where order_total > 50
How do i implement group by and having together in this queries ??
There's an example on this page:
Oracle Group By Having SQL PL/SQL
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.
But, there's nothing to "group by" in your query (at least, I don't see any reason for that).
Otherwise, you'd (probably) have SUM(O.ORDER_TOTAL) and the rest of the columns would have to be specified in the GROUP BY clause.