LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 367 users online 166221 members 470 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Video | Dictionary | News | FAQ
You have 1 new message.
Emergency Help
Until you sign up you can't do much. Yes, it's free.

Sign Up Now
Membername:
Password:
Already have an account?
Invite Friends
Active Members
Groups
Contests
Moderators
5 online / 17 MPM
Fresh Topics
  LiveWire / Technical Forums / Software Tech Support / Viewing Topic

OHAI I NEED HELP WITH SQL/ORACLE
Replies: 5Last Post April 11 6:21pm by Elephantis
Single page for this topic Email Print Favorite
( i who have nothing )


Executive

Patron
Reply
so i wrote this query

SELECT COUNT(*) FROM orderdetails
WHERE (unitprice * quantity) > AVG( SUM(unitprice*quantity) )
GROUP BY orderid

and i keep getting this silly "Invalid relational operator error" error.  PLEAZE HALP.

and if you don't know anything about what i'm talking about, please reply anyways.  i like seeing your words. :)

-------
Want more of me?  Check out my BLOG.
Share your mp3's for free HERE.


5:04 pm on April 11, 2008 | Joined Mar. 2008 | 95 Days Active
Join to learn more about i who have nothing Ontario, Canada | Straight Male | 2565 Posts | 3505 Points
Post from this position was omitted due to content violations
Post from this position was omitted due to content violations
Post from this position was omitted due to content violations
MattJ


Dairy Product Addict

Patron
Reply
do you have a running subscription? i have no idea what you are talking about, I am just saying random blah


-------
SUBWAY FTW!!!

5:13 pm on April 11, 2008 | Joined Mar. 2008 | 64 Days Active
Join to learn more about MattJ Indiana, United States | Straight Male | 1113 Posts | 1650 Points
Elephantis


Wealthy Hobo

Sustainer
Reply
I have no idea what you're talking about, but my words are beautiful.

-------
It's time you invested in a bottle of poison.
So we don't have to hear about you bitchin and moanin.
You think you could afford a f*ckin bottle of asprin.

6:21 pm on April 11, 2008 | Joined June 2007 | 299 Days Active
Join to learn more about Elephantis Ontario, Canada | Straight Female | 2541 Posts | 5041 Points
Single page for this topic Email Print Favorite

Quick Reply

You are signed in as our guest.

Looking for something else?
 

  LiveWire / Technical Forums / Software Tech Support / Viewing Topic