Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
  • Members Only
  • Post
  • Files
  • Photos
  • Database
  • Polls
  • Members
  • Calendar
  • Promote
  • Groups Labs (Beta)
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

   Messages Help
Message #
Search:
Advanced
query question   Message List  
Reply | Forward Message #2064 of 3878 |
Re: [baseball-databank] query question

We at WEBEUSA, custom design websites for the business community. If you are interested in a website for your business or want to upgrade your site please check us out at our website at www.webeusa.com . Check out our portfolio, click on the prices on the home page and you will see a demo of the site we can custom design for you and your business. Also check out our hosting features and prices. We also now optimize your website, keeping it in the top 50 for a fee. For further details and for a free web consultation please call me at 866-703-6565 or email me at joe@... . 

Joe Goldner

954-597-2929

joe@...

www.webeusa.com

 

rscarpel <rscarpel@...> wrote:
Would anyone know how to do a query where I could get the following
output:  Player ID, Year, Total Fielding Games, Games at Catcher.

I am trying to get one line for each players year that will tell me
total fielding games for the year with the number of fielding games
at catcher for that season next to it.

Thanks for any help.



http://www.baseball-databank.org/


Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
Sat Mar 27, 2004 2:09 am

Show Message Option
web_e_usa2004
Offline Offline
Send Email Send Email

Forward 		Message #2064 of 3878 |
Expand Messages Author Sort by Date

Would anyone know how to do a query where I could get the following output: Player ID, Year, Total Fielding Games, Games at Catcher. I am trying to get one... 		rscarpel
Offline Send Email 		Mar 26, 2004
3:13 pm

... Either of the following will get what you describe: SELECT first(playerID) as Player, first(yearID) as Year, sum(G) as [Total Fielding Games], ...
Michael Mavrogiannis
mmavrogi
Offline Send Email 		Mar 26, 2004
7:11 pm

Try something like: select playerid, year, sum(g) as Gtot, sum(Iif(pos=2,g,0)) as G2 from fielding group by playerid, year This will only work with Access. I...
tmasc@...
tangotiger
Offline Send Email 		Mar 27, 2004
12:54 am

MySQL also has an IF expression with a similar syntax. PostgreSQL has a CASE-WHEN construct that should accomplish the same thing (I think). Randy System...
Randy Fiato
rfiato
Online Now Send Email 		Mar 27, 2004
1:56 am

We at WEBEUSA, custom design websites for the business community. If you are interested in a website for your business or want to upgrade your site please...
Joe Goldner
web_e_usa2004
Offline Send Email 		Apr 3, 2004
4:54 am
< Prev Topic  |  Next Topic >
Message #
Search:
Advanced
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help