Order by

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Max Mulawa SSC Enthusiast Points: 174 More actions · Answer 1

Hi,

Select * from T1 WHERE id = 100

UNION ALL

Select * from T1 WHERE id 100 order By NewID()

I hope this will be useful

Max

Jesper-244176 SSCertifiable Points: 7142 More actions · Answer 2

Another possibility is to sort by a case statement, like the following:

order by case when id = 100 then -1 else id end

David Burrows SSC Guru Points: 65142 More actions · Answer 3

This will not work for 2 reasons

1. newid() has to be in the select for the order by to work (you will get an error)

2. order by affects the whole query and therefore even if the above worked it would not produce the right result

Jesper is on the right track and if I understand your question correctly this is what you require

Select * from T1

order By CASE WHEN itemid=100 THEN -1 ELSE 1 END, NewID()

Far away is close at hand in the images of elsewhere.
Anon.

Anthony Zackin SSC Enthusiast Points: 154 More actions · Answer 4

Here's another possible solution although it does create an extra useless column. However this technique might be useful for other applications.

use

pubs

go

select 0 as " ",* from titles where titles.royalty = 10

union

all

select

1,* from titles where titles.royalty <> 10

order

by 1,royalty desc

go