Skip navigation

August MDX Puzzle - 17 Jul 2000

Suppose you're developing an application that must provide users access to large amounts of information, and you decide the best method is to display the data one page at a time (a page is 50 rows). If a user asks for unit sales to each customer during the four quarters of 1997, how would you write the query to return the first page of data? Remember, you want to return the customers in the order that they appear in the sales cube.

TAGS: SQL
Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish