LiveWire Network Peer Answers Peer Support Teen Forums Tech Forums College Forums 706 users online 211221 members 1678 active today Advertise Here Sign In
TeenCollegeTechPhotos | Quizzes | LiveSecret | Memberlist | Dictionary | News | FAQ
Member Spotlight
Katx
Music: Local, screamo, alt., acoustic, hardcor...
Mood: Pleased
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 / 56 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, 2008 11:55am by Link01
Welcome to LiveWire!
We're Stronger Together.
Join the Community
Single page for this topic Email Print Favorite
( HelloNerds )


Lawn Care Specialist
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 | Days Active: 17
Join to learn more about HelloNerds Canada | Posts: 43 | Points: 113
pleaseremove


meh

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 | Days Active: 1,281
Join to learn more about pleaseremove England, United Kingdom | Straight Male | Posts: 5,928 | Points: 35,696
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 | Days Active: 959
Join to learn more about Link01 Wales | Straight Male | Posts: 35,817 | Points: 45,249
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