QOD 12/17/03

Question

QOD 12/17/03

TomBrattin

SSCrazy

Points: 2436
More actions
December 16, 2003 at 7:36 pm

#106662

I feel sorry for this company. They just fired the top 5% of their salesmen:
Correct Answer:
SELECT TOP 5 PERCENT FIRST_NAME, LAST_NAME
FROM Sales ORDER BY TOTAL_SALES DESC
Since ordering by DECENDING sales will put the top salesmen first on the list.

Viewing 15 posts - 1 through 15 (of 43 total)

You must be logged in to reply to this topic. Login to reply

Stuart73 SSC Enthusiast Points: 172 More actions · Answer 1

You' right! And also feel sorry for the people that missed out on those two points... okay, mostly because it would be my first two points!

ausgate SSC Enthusiast Points: 127 More actions · Answer 2

So for those of us that actually answered the right option "None Of The Above" won't get our dearly earned points.

Not that i'm worried with a 47% rate after a hundred or so questions 🙁

sjtaylor SSChasing Mays Points: 607 More actions · Answer 3

Whew - I thought I was the one confused by ascending and descending, it's actually the answer that's incorrect...

SJT

iplman SSC-Addicted Points: 498 More actions · Answer 4

I guess that they couldn't give us our 2 points anyway. They probably couldn't get the SQL correct! 🙂

Nick Beagley Ten Centuries Points: 1349 More actions · Answer 5

Nick Beagley

Ten Centuries

Points: 1349

December 16, 2003 at 9:23 pm

#486558

hahaha good call iplman 🙂

sujithtv Valued Member Points: 64 More actions · Answer 6

I just started a company, i'd like those 5 salesperson to join my company!!!!!.

Mohit Nayyar Ten Centuries Points: 1008 More actions · Answer 7

Yes Tom

Even i feel sorry about the current answer. I even can't imagine that a site like SQLServerCentral can approve questions like this.

Mohit Nayyar

MCP (.Net), MCSD, MCDBA

Thanks
Mohit Nayyar
http://mohitnayyar.blogspot.com/
"If I am destined to fail, then I do have a purpose in my life, To fail my destiny"

pshotts Right there with Babe Points: 784 More actions · Answer 8

Quite disappointing that such a gross blunder slipped through.

On the other hand, it does not happen often, and, if we're honest, it may even add to the pleasure of trying our skills every day with the Question.

Razvan Socol SSCarpal Tunnel Points: 4811 More actions · Answer 9

Wrong "correct answer", but right Explanation...

QOD is getting worse every day. Yesterday it was a minor mistake about an underline, today is a huge difference between DESCending and ASCending.

Needless to say that I answered "None of the above" and... I want my points back !

Razvan

Frank Kalis SSC Guru Points: 111183 More actions · Answer 10

While I agree that the last two QODs were poorly formulated, I would like to invite everybody who complains to sit down and submit their own QODs.

Some time ago I said I am about to do so, but I tell you what might look easy, turns out to be a really difficult and frustrating task. Complaining is easier.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Rohit @ SQL SSC Eights! Points: 938 More actions · Answer 11

there is much more than Points that i earned by answering the question that in future i can think this thing in my mind that i am always not wrong in answering the questions sometimes question is also wrong

Feeling more confident !!!

Rohit

Ojamie Valued Member Points: 55 More actions · Answer 12

Agreed, complaining is easy. But when you claim to be the largest sql community on earth, it looks silly not to live upto those standards.

It is not just QOD. Some of the articles (even written by site owners)that are being published lately are pretty poor too.

Dave Francis Old Hand Points: 328 More actions · Answer 13

Phew, I'm not going mad then. But I agree most of the questions are a great way to start the brain in the morning.

ErikBr Right there with Babe Points: 726 More actions · Answer 14

A missing character is a typo error.

The difference between asc and desc is something else.

As a lot of my colleagues noted, the so called correct answer is wrong.

Please change this QOD as fast as possible with appologies to the members. Everybody can make mistakes. But please correct it!

I don't care about the points, but some people might think they answered right, while they were wrong.

These kind of errors may reflect on the community.