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

ÇóÒ»¸öSQL²éѯÓï¾ä - .NET¼¼Êõ / C#

ÏÖÓÐÒ»¸ö±í Book
Book±íÄÚÈÝ´ó¸ÅÈçÏ£º
BookID BookName Grade Subject
1 AAA Ò»Äê¼¶ ÓïÎÄ
2 BBB Ò»Äê¼¶ Êýѧ
3 CCC ¶þÄê¼¶ ÓïÎÄ
4 DDD ÈýÄê¼¶ Êýѧ
5 EEE ÎåÄê¼¶ Êýѧ
6 FFF °ËÄê¼¶ ÎïÀí
7 GGG ¶þÄê¼¶ Êýѧ
8 HHH ¶þÄê¼¶ Ó¢Óï
9 III ÈýÄê¼¶ Êýѧ
10 JJJ ¾ÅÄê¼¶ »¯Ñ§

´ó¸Å¾ÍÕâÑùÁË£¬ÏÖÔÚÎÒÏëÈ¡³öGradeÖеļǼҪ²»Öظ´µÄ£¬²¢ÇÒ°´ÕÕÒ»Äê¼¶ ¶þÄê¼¶ ÈýÄê¼¶....ÕâÑùÅÅÐò

ÇëÎÊÕâ¸öSql²éѯÓï¾äÔõôд£¿£¿£¿
1£©select DISTINCT Grade from Book order by charindex(left(Grade,1),'Ò»¶þÈýËÄÎåÁùÆß°Ë¾ÅÊ®')
2£©Select Grade from(select distinct Grade from Book as Book_order order by charindex(left(Grade,1),'Ò»¶þÈýËÄÎåÁùÆß°Ë¾ÅÊ®')) 
ÒÔÉÏÕâÁ½¸ö¶¼ÊÇ´íÎóµÄ¡£

ÇóÕýȷд·¨£¬Ð»Ð»

ÆäʵÎÒµÄÏë·¨¾ÍÊÇÏȰÑÊý¾Ý¹ýÂËһϵõ½²»Öظ´µÄ×ֶΣ¬Ò²¾ÍÊÇÄê¼¶£¬È»ºóÔÙÅÅÐòÒ»ÏÂ
select DISTINCT Grade from LTKT_Book order by GradeÒ²¾ÍÊÇÕâÑù£¬¿ÉÊÇSQLĬÈϵÄÅÅÐò²»ÄÜÅÅÖÐÎÄÊý×Ö
û·¨²é...ÄãΪʲô²»°ÑÄê¼¶¸Ä³Éint 1±íʾ1Äê¼¶ 2±íʾ2Äê¼¶ È»ºóÅÅÐò

SQL code:

select DISTINCT Grade from LTKT_Book order by order by (case Grade when 'Ò»' then 1 when '¶þ' then 2 ...end)




SQL code



Code highlighting produced by Actipro CodeHighlighter (freeware)
http


Ïà¹ØÎÊ´ð£º

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



type Exception report


message

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

exception

org.apache.jas ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

Çë´ó¼ÒÖ¸µãÒ»ÏÂC/S½á¹¹µÄ·ÖÒ³Á÷³Ì - .NET¼¼Êõ / C#

´ó¼ÒºÃ£¬ÎÒÊÇÐÂÊÖ£¬¸Õ¿ªÊ¼½Ó´¥C/S½á¹¹µÄ³ÌÐò£¬ÏëҪʵÏÖÒ»¸ö·ÖÒ³¹¦ÄÜ£¬´ó¼ÒÓÐûÓкõãµÄ·ÖÒ³¿Ø¼þ»òÕß³ÌÐòÖ®ÀàµÄ£¬µ±È»Ô´³ÌÐò¸üºÃ£¬·ñÔò˵˵Á÷³ÌÒ²¿ÉÒÔ£¬Ð¡Ãü±°¡£¬ÔÚÏߵȡ£¡£¡£¡£
´ó¼Ò°ï°ï棬ллÁË£¬¼±¡£¡£¡£

Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ