SQLÊý¾Ý²éѯÅÅÐò - .NET¼¼Êõ / ASP.NET
±íÃû lshg ×Ö¶ÎÃûstate ÏÂÃæÊÇÊÇÊý¾Ý 13.58% 9.88% 29.82% 7.86% ʧ°Ü 27.55% 9.27% 4.93% 16.67% 22.85% 16.56% 2.44% 5.80% 16.80% 14.14% 8.37% 9.38% 13.96 24.21% 10.75% Ôõô¸øËû½øÐÐÖØ´óµ½ÏÂÅÅÐò
¸ø×Ô¼º¶¥¸öÏÈ select * from lshg order by state descÒýÓà select * from lshg order by state desc UP ²»ÐÐ ÀïÃæµÄÊý¾ÝÊÇvarcharÀàÐÍµÄ Â¥ÉÏÕý½â ÐÞ¸ÄÄãµÄ±í¶¨Ò壬 Õâ·ÖÃ÷ÊǸöÓв¡µÄ±íÉè¼Æ£¡£¡ ÕæµÄûÓбðµÄ°ì·¨Âð ÕæµÄûÓбðµÄ°ì·¨Âð Äã¿ÉÒÔн¨Ò»¸öÁÙʱ±í¡£¡£´´½¨Ò»¸öINTµÄ×ֶΡ£¡£°ÑÄãstateÀïÃæµÄÊý¾ÝµÄ°Ù·ÖºÅÇ°ÃæµÄÒ»ÌõÌõ²åÈëµ½ÁÙʱ±íÀïÃæ¡£¡£ÔÙ¸ù¾ÝÁÙʱ±íµÄÊý¾Ýorderby create table #Temp (aaa nvarchar(50)) insert into #Temp select '13.58%' union select '9.88%' union select '29.82%' union select '7.86%' union select N'ʧ°Ü' union select '27.55%' select * from #Temp order by case aaa when N'ʧ°Ü' then 1000 else convert(float,substring(aaa,1,len(aaa)-1)) end SQL code: select *,substring(state,1,len(state)-1) from a order by cast(substring(state,1,len(state)-1) as decimal) desc SQ
Ïà¹ØÎÊ´ð£º
function CheckOpwd(){//ÑéÖ¤Óû§Ãû var pwd=document.all.txtOpwd; var div1=document.getElementById("divPwd"); if (pwd.value=="") { ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server) µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......