Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql²éѯ¿ÕÐÐ

Ò»¸ö±íA
id name password
1  aa  ccc
2  bb  eee
3  hh  mmm

ÈçºÎÄÜÏÔʾ³ÉÒ»ÐпÕÒ»ÐÐ
1  aa  ccc

2  bb  eee

3  hh  mmm


»¹ÓÐÄܲ»ÄÜÏÔʾΪһÐпÕÒ»ÐУ¬ÁÐÒ²Ò»ÐпÕÒ»ÐÐ
1  ¿Õ  aa  ¿Õ  ccc

2      bb      eee

3      hh      mmm

ÇóÖúÏ´ó¼Ò

ÔΠ ÕâÑùµÄÐèÇó

ÁÐÓ¦¸Ã¿ÉÒÔ¼Ó¿Õ¸ñ ÐÐÔõô¸ãµÈ¸ßÈË

µ¹£¬Õâ¸öÔÚ³ÌÐòÖÐÈ¥²¼¾ÖÑùʽ¾ÍÐÐÁË¡£
¸ÉÂïʲô¹¦Äܶ¼ÈÃÊý¾Ý¿âÀ´´¦Àí£¿

ÒýÓÃ
µ¹£¬Õâ¸öÔÚ³ÌÐòÖÐÈ¥²¼¾ÖÑùʽ¾ÍÐÐÁË¡£
¸ÉÂïʲô¹¦Äܶ¼ÈÃÊý¾Ý¿âÀ´´¦Àí£¿

ͬÒâ,

ÕâÖÖÈËÊÇÀ´ÕÒ³éµÄ

select id , name , password from
(
select cast(id as varchar) id , name , password , px = id from a
union all
select '' , '' , '' , px = id from a
) t
order by px , case when name = '' then 2 else 1 end


ÒýÓÃ
SQL codecreatetable a(idint, namevarchar(10) , passwordvarchar(10))insertinto avalues(1 ,'aa' ,'ccc')insertinto avalues(2 ,'bb' ,'eee')insertinto avalues(3 ,'hh' ,'mmm')goselect id , name , passwordfr?-

Å£²æ°¡

Õâ


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ