I'm Confused

  • Answer 1` and 2 in my email are identical. What am I missing?

    Your company is about to layoff 5 percent of its sales force and you have been tasked with the morbid task of determining which of your salespeople are poor performers. To do this, you're required to find the bottom 5% of your sales force based on their total sales (TOTAL_SALES column). What T-SQL statement would accomplish this?

    (This Answer) - SELECT TOP 5 FIRST_NAME, LAST_NAME

    FROM Sales ORDER BY TOTAL_SALES DESC

    (This Answer) - SELECT TOP 5 PERCENT FIRST_NAME, LAST_NAME

    FROM Sales ORDER BY TOTAL_SALES DESC

    (This Answer) - SELECT BOTTOM 5 PERCENT FIRST_NAME, LAST_NAME

    FROM Sales ORDER BY TOTAL_SALES

    (This Answer) - SELECT BOTTOM 5 FIRST_NAME, LAST_NAME

    FROM Sales ORDER BY TOTAL_SALES

    (This Answer) - None of the above

  • This QOD is particular because as you can see in the other topic, the correct answer is wrong, because 'None of the above' is the right one.

    But check answers 1 and 2 and you will notice that they are different. One used TOP 5 PERCENT and the other only TOP 5.

  • I knew I was missing something.

Viewing 3 posts - 1 through 2 (of 2 total)

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