WRONG ANSWER

• vijaydwivedi

  SSC Enthusiast

  Points: 119

  More actions

  December 17, 2003 at 1:24 am

  #107427

  SELECT TOP 5 PERCENT FIRST_NAME, LAST_NAME

  FROM Sales ORDER BY TOTAL_SALES DESC

  this query is wrong.For correct result use

  SELECT TOP 5 PERCENT FIRST_NAME, LAST_NAME

  FROM Sales ORDER BY TOTAL_SALES ASC

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 17, 2003 at 1:26 am

  #486569

  There is already a thread on this QOD

  http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=19291

  Please use this one

  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]