We help IT Professionals succeed at work.
Get Started

sql order by question

395 Views
Last Modified: 2010-03-19
Here is my table of values

Market      MarketName

2001      Albuquerque
2002      Birmingham
2003      Central Alabama
2004      Central Florida
2005      Central/NW Austin
2006      Denver
2007      DFW Metro
2008      DFW North
2009      DFW South
2010      DFW West
2011      Eastern
2012      Gulf Coast
2013      Mobile
2014      NE Florida (Jaxs)
2015      North Alabama
2016      North Houston
2017      Northern
2018      San Antonio/SE Austin
2019      South Houston
2020      Southeast Alabama
2021      Southern
4001      Alabama /Florida
4002      Arizona/Colorado
4003      North Texas/New Mexico
4004      South Central Texas
10001      Corporate

I need this ordered as follows:  First, I need every record with a market of 4000 and higher order by that the field market in descending order.  Then I need all markets less than 4000 ordered alphabetically by the field marketname.  Is it possible to order two different ways with the same table of data?
      
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE