ÇóÒ»¸ö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
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
´ó¼ÒºÃ£¬ÎÒÊÇÐÂÊÖ£¬¸Õ¿ªÊ¼½Ó´¥C/S½á¹¹µÄ³ÌÐò£¬ÏëҪʵÏÖÒ»¸ö·ÖÒ³¹¦ÄÜ£¬´ó¼ÒÓÐûÓкõãµÄ·ÖÒ³¿Ø¼þ»òÕß³ÌÐòÖ®ÀàµÄ£¬µ±È»Ô´³ÌÐò¸üºÃ£¬·ñÔò˵˵Á÷³ÌÒ²¿ÉÒÔ£¬Ð¡Ãü±°¡£¬ÔÚÏߵȡ£¡£¡£¡£
´ó¼Ò°ï°ï棬ллÁË£¬¼±¡£¡£¡£
Ä ......