Re: How do u SELECT this one? SELECT rank=count(*)
From: Joe Celko (jcelko212_at_earthlink.net)
Date: 11/06/04
- Next message: Joe Celko: "Re: Insert with response"
- Previous message: Hugo Kornelis: "Re: Insert with response"
- In reply to: mekim: "Re: How do u SELECT this one? SELECT rank=count(*)"
- Next in thread: Hugo Kornelis: "Re: How do u SELECT this one? SELECT rank=count(*)"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 06 Nov 2004 13:50:18 -0800
>> Using COUNT(DISTINCT ..) doesn't seem to cut it... but that probably
means I'm using it wrong <<
When you are trying to get other people to do your homework, you might
want to put more effort into yourself when you get a hint.
I usually do not even give hints. I hunt down the student who is
attempting to cheat and report him to the dean of the department.
--CELKO--
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are. Sample data is also a good idea, along with clear
specifications.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Joe Celko: "Re: Insert with response"
- Previous message: Hugo Kornelis: "Re: Insert with response"
- In reply to: mekim: "Re: How do u SELECT this one? SELECT rank=count(*)"
- Next in thread: Hugo Kornelis: "Re: How do u SELECT this one? SELECT rank=count(*)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
