Re: Thanks was RE: returning top 10

2000-10-17 Thread Hong 

sounds familiar? are you doing your database class homework or
something??

maybe you can use:
SELECT blah...
FROM   blah...
WHERE  ... NOT IN ( query_select_top_10_countries )

Hong

Jim Watkins wrote:
 
 So far so good.  Now I have written another script that selects everyone NOT
 in the top ten counties (rows).  How can I do that without naming the
 counties?
 
 -Original Message-
 From: Jim Watkins [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 16, 2000 9:09 PM
 To: CF-Talk
 Subject: returning top 10
 
 How do you write a SQL statement that will return the top 10 of something
 (eg. top 10 salaries, top ten students by GPA, top ten populated counties,
 etc.)?
 
 Currently I have:
 and student_pop
 in('Towns','Union','White','Fannin','Habersham','Stephens','Rabun','Franklin
 ','Bibb','Jones')
 
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Thanks was RE: returning top 10

2000-10-16 Thread Jim Watkins 

So far so good.  Now I have written another script that selects everyone NOT
in the top ten counties (rows).  How can I do that without naming the
counties?

-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 9:09 PM
To: CF-Talk
Subject: returning top 10


How do you write a SQL statement that will return the top 10 of something
(eg. top 10 salaries, top ten students by GPA, top ten populated counties,
etc.)?

Currently I have:
and student_pop
in('Towns','Union','White','Fannin','Habersham','Stephens','Rabun','Franklin
','Bibb','Jones')



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Thanks was RE: returning top 10

2000-10-16 Thread Rick Osborne [Mojo] 

Easiest way?  Recycle your new "Top 10" query as a subquery.

SELECT student_pop
FROM table1
WHERE student_pop NOT IN (
  SELECT top 10 student_pop
  FROM table1
  ORDER BY whatever
)

-Rick

-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 22:55
To: CF-Talk
Subject: Thanks was RE: returning top 10


So far so good.  Now I have written another script that selects everyone NOT
in the top ten counties (rows).  How can I do that without naming the
counties?

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.