ylekot88
Last Activity: Apr 11 '09, 02:48 AM
Joined: Dec 1 '08
Location:
-
will not post to save my life
Hello. Yes, I am a newbie to Javascripting for a whole 3 weeks now. I have been given an assignment in a book that is horribly worded, and I have spent about 30 hours trying to figure out what I am doing wrong. The assignment itself is from the "javascript new perspectives" book, and gives about 25 steps stating what you need to do next, not really giving clear directions. What I can gather: the book gives an .htm pg, a .css, & a .js... -
max(orderdate)not working in subquery
hi
I am having problems with the max(orderdate) not generating the most recent orderdate of each customer's order. My code is this, with the results following
select firstname,lastn ame,orderdate,( sum(retail*quan tity))"total profit"
FROM customers join orders using (customer#)
join orderitems using (order#)
join books using (isbn)
where orderdate in (select max(orderdate)
... -
fetched results not separating
I am using Oracle 10g SQL,
This is my first try at PL/SQL so I have no idea what I should be looking for, or why the output works (sort of) when its just listed as v_customer# || v_order# || v_sum || v_orderdate, but the moment I add 'customer#:' before the v_customer# I get this error message.
All your help is greatly appreciated!
my error msg is this:... -
fetched results not separating
I am working on an anonymous pl/sql block that is supposed to retrieve & output customer#, date & total price of each order, listed by order date in chronological order. My pl/sql statement is producing the right answer, but as one long number followed by the date. ex 1005100026.5731-MAR-05 is supposed to be customer# 1005 order# 1000 total price 26.57 order date 31-Mar-05
when I try to separate the answer in the DBMS_output.put _line... -
group by works, order by error msg/with code
Thanks for getting back to me, I can't believe I forgot to add the code! lol
what I am looking to do:
list customer#, date, and total price of each order. ensure results are in chronological order based upon order date
the following select statement with just a group by (which works) :
select customer#, order#, sum(quantity*re tail) "total...Leave a comment:
-
group by works, order by gives error msg
Hi
I am a student, I am trying to figure this out. I am trying to run a select statement that is asking for customer#, date, and total price of each order. ensure results are in chronological order based upon order date.
When I run the following with just a group by clause, it works. If I add order by orderdate, I get an error message that states SQL Error: ORA-00979: not a GROUP BY expression. Why is the order by...
No activity results to display
Leave a comment: