| SitePoint Sponsor |
|
|
User Tag List
Results 1 to 3 of 3
-
Jan 16, 2006, 05:22 #1SitePoint Addict
- Join Date
- Jan 2005
- Location
- Hiding from the world
- Posts
- 358
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Starting an order by query in a specific place?
Hi,
is it possible to start an ORDER BY query in a certain place. for example if i have ID numbers
1
2
3
4
5
can i ORDER BY id starting at 2 thereby giving me
2
3
4
5
1
or is this impossible ? ThanksIf i am a product of your imagination you should try harder!
-
Jan 16, 2006, 06:09 #2SQL Consultant
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
ORDER BY case when fld > 1 then 9 else 37 end, fld
-
Jan 16, 2006, 07:38 #3SitePoint Addict
- Join Date
- Jan 2005
- Location
- Hiding from the world
- Posts
- 358
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
cool thanks i'll gave that a try.
If i am a product of your imagination you should try harder!
Bookmarks