|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 10th, 2002, 11:15 AM
|
|||
|
|||
|
Order by using two different values
I am wondering how I would use the ORDER BY query, to order a set of results using two different fields.
So it first of all order the cat_id in to number order. But as there will be serveral different rows with the same cat_id, I would then like to make it put in order by cat_order depending on the cat_id. So is this possible.
|
|
#2
August 11th, 2002, 12:02 PM
|
||||
|
||||
|
ORDER BY cat_id, cat_order
__________________
Casuistry Agnostic
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Order by using two different values |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
