ÇóÒ»¸ö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
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
ÓÃlistviewÏÔʾ³ö´ÓÊý¾Ý¿âÖвéѯ³öµÄ¼Ç¼£¬ÏëÔÚ×îºó¼Ç¼ºóÃæÌí¼ÓÒ»ÌõºÏ¼ÆÐУ¬ÈçºÎʵÏÖ£¡Ð»Ð»´ó¼Ò£¡
°ó¶¨Êý¾ÝÄãÓ¦¸ÃûÎÊÌâ°É£¬°ó¶¨ÍêÒÔºóÓÃÒ»¸öÑ»·°ÑÄãҪͳ¼ÆÊý¾ÝµÄÁÐÖеÄÊý¾Ý×ܺÍÓÃÒ»¸ö±äÁ¿½ÓÊÜ£¬È»ºóÔÚÑ»·ÍâÃæne ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......