Skip navigation

August 2003 MDX Puzzle

The number-one item in the main article shows how to find the top 10 single, female customers based on unit sales. How would you rewrite that example query to find the top 10 customers based on unit sales who aren't single and female? Can you do it without listing all three of the other combinations (i.e., single male, married male, and married female)?

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