To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.db.invOpen lugnet.db.inv in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Database / Set Inventories / 1525
1524  |  1526
Subject: 
Re: New features at Peeron.com
Newsgroups: 
lugnet.db.inv
Date: 
Wed, 12 Feb 2003 14:48:49 GMT
Viewed: 
2203 times
  
On Wed, Feb 12, 2003 at 06:19:31AM +0000, David Schilling wrote:
One interesting query that I've wondered about is what is the set with the
most number of odd elements? Most sets seem to have an even number of most
parts.

heh, never thought to look at that.  I'm still thinking of the best way
to implement that in a report (still learning SQL :), but here's the
short answer:

<set:6543-1> - it has 174 different parts in odd quantities!

Here's the top 10:

<set:6543-1> - 174
<set:6597-1> - 173
<set:6542-1> - 149
<set:4709-1> - 148
<set:6575-1> - 145
<set:5987-1> - 141
<set:5978-1> - 140
<set:6559-1> - 136
<set:5988-1> - 135
<set:6395-1> - 131

:)

Dan



Message is in Reply To:
  Re: New features at Peeron.com
 
(...) I love the new features! Thanks! One interesting query that I've wondered about is what is the set with the most number of odd elements? Most sets seem to have an even number of most parts. -- David Schilling (22 years ago, 12-Feb-03, to lugnet.db.inv)

11 Messages in This Thread:




Entire Thread on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact
    

Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR