不该问的sql 语句.谢谢(15分)

D

devexpress

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #1

bh
3
2
1
null
null


用　order by bh

3
2
1
null
null
用order by bh desc
null
null
1
2
3
但我想的结果是
1
2
3
null
null
这个语怎样写

 

D

devexpress

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #2

我真的没分了。

 

K

karxios

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #3

select bh,'aa'= case when (xh is not null) then xh else '99999' end from *** order by aa

 

K

karxios

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #4

没分可以打白条呀

 

D

devexpress

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #5

多人接受答案了。