SQLTeam.com | Weblogs | Forums

Need Help with Project


#1

Having problems with this Query. I am getting the error saying missing expression.

CREATE OR REPLACE VIEW QuestionI1
AS (SELECT e.Employeeid, e.firstname, e.lastname
, sum(nvl(e.salespercent*.01nvl(s.sellprice,0),0)) HighestComm
FROM Employee e
JOIN Salesinv s
ON (e.employeeid = s.salespersonid)
GROUP BY s.salespersonid
HAVING
(select max(sum(nvl(e.salespercent
.01*nvl(s.sellprice,0),0)))
FROM Employee e
JOIN SalesInv s
ON (e.employeeid = s.salespersonid)
GROUP BY e.Employeeid)
);


#2

is this for Microsoft SQL server?


#3

I am doing it on Oracle APEX SQL workshop


#4

Please note that this forum is for Microsoft SQL server and you may not find the answer to an Oracle question here.