ÇóÒ»¸ö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
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
VS2008ÖÐC#²Ù×÷AccessÊý¾Ý¿â£¬ÍøÉÏÏÂÔØÁËÒ»¸öÀ࣬¿ÉÒÔÕý³£Á¬½Ó£¬¶ÁÈ¡Êý¾Ý£¬µ«ÊDzåÈëɾ³ý²Ù×÷ËÆºõÓÐÎÊÌ⣬ÒÔÏÂÊDz¿·Ö´úÂ룺
Êý¾Ý¿âÀࣺ
namespace AccessDb
{
public class AccessDbClass
{ ......
´ó¼ÒºÃ£¬ÎÒÊÇÐÂÊÖ£¬¸Õ¿ªÊ¼½Ó´¥C/S½á¹¹µÄ³ÌÐò£¬ÏëҪʵÏÖÒ»¸ö·ÖÒ³¹¦ÄÜ£¬´ó¼ÒÓÐûÓкõãµÄ·ÖÒ³¿Ø¼þ»òÕß³ÌÐòÖ®ÀàµÄ£¬µ±È»Ô´³ÌÐò¸üºÃ£¬·ñÔò˵˵Á÷³ÌÒ²¿ÉÒÔ£¬Ð¡Ãü±°¡£¬ÔÚÏߵȡ£¡£¡£¡£
´ó¼Ò°ï°ï棬лÁË£¡
×Ô¼ºÐ´Ñ½£¡
......