LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 387 users online 166215 members 376 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
4 online / 23 MPM
Fresh Topics
  LiveWire / Technical Forums / Programming & Application Development / Viewing Topic

SQL Help
I cant figure out this SQL, need a little push
Replies: 2Last Post Mar. 14 11:55am by Link01
Single page for this topic Email Print Favorite
( HelloNerds )


Grasshopper
Reply
I have about 20 questions to do in my SQL class and cant figure out what commands to use. The teacher usually gives an example to get us going, if anyone know the proper SQL query, could you help out? Here's the question

Query 1:
Return the employee id and the total number of orders that each employee processed from the orders table, sort the total from highest number to lowest.


2:21 pm on Mar. 13, 2008 | Joined Nov. 2007 | 11 Days Active
Join to learn more about HelloNerds Canada | 27 Posts | 37 Points
pleaseremove


Dairy Product Addict

Patron
Tech Support Leader
Reply
We can't help you with this without knowing the structure of your database.

-------
Anyone who isn't confused really doesn't understand the situation
http://craigk.org/pictures/
Can you work out the code?

4:50 pm on Mar. 13, 2008 | Joined Feb. 2005 | 1058 Days Active
Join to learn more about pleaseremove England, United Kingdom | Straight Male | 5375 Posts | 29410 Points
Link01


Time Lord

Patron
Reply
you would use

SELECT From;

-------
Doctor who - Wibbly Wobbly Timey Wimey!
used to show time travel's effects.


11:55 am on Mar. 14, 2008 | Joined Feb. 2006 | 658 Days Active
Join to learn more about Link01 Wales | Straight Male | 29948 Posts | 36333 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 / Programming & Application Development / Viewing Topic