sqlserver order byÅÅÐòÎÊÌâ - .NET¼¼Êõ / ASP.NET
Order by ʱ¼ä×Ö¶Î desc ÅŲ»ÁË˳ÐòÁË Ç°ÌáÊÇÎÒÕâ¸öÊÇÒ»¸öÊÔͼ£¿ ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡£¡ºÜÊÇÓôÃÆ£¡Ï£Íû¸÷Ϊ¸ßÊÖÖ¸µã£¡£¡ ¼±¼±£¡£¡£¡£¡
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡ Õâ¾ä»°ÎÒ¿´²»¶®ÒýÓà ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡ Õâ¾ä»°ÎÒ¿´²»¶® replace ÊÔͼ with ÊÓͼ Ö´ÐÐsqlÓï¾äºó³öÀ´µÄÊý¾Ý¼¯Ó¦¸ÃÊÇÅÅÐòµÄѽ£¬ÊÓͼ±¾ÉíÊDz»»á±äµÄ ¿àÄÕ¡£¡£ Ôõô¾õµÃÄã˵µÄ¶¼ÊÇÕý³£ÏÖÏ󡣡£ ¹û¶ÏÌù³ö´úÂë ºÃµÄ£¡£¡ÉÔµÈ SELECT TOP (100) PERCENT dbo.LBsiT_¿Í·þ¼Ç¼.ID, dbo.LBsiT_¿Í·þ¼Ç¼.¼Ç¼ʱ¼ä, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÂÓÉ, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÖд¿Í»§ÐÕÃû, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§±àÂë, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§µç»°ºÅÂë, dbo.lbsit_¿Í»§.µØÇø, dbo.LBsiT_¿Í·þ¼Ç¼.Ïà¹Ø¶©µ¥±àºÅ, dbo.LBsiT_¿Í·þ¼Ç¼.Ïà¹Ø²úÆ·±àÂë, dbo.LBsiT_¿Í·þ¼Ç¼.ÏêÇé¼Ç¼, dbo.LBsiT_¿Í·þ¼Ç¼.´¦Àí·½°¸, dbo.LBsiT_¿Í·þ¼Ç¼.¿Í·þרԱ, dbo.LBsiT_¿Í·þ¼Ç¼.´¦Àí½á¹û, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÛºóרԱ, dbo.LBsiT_¿Í·þ¼Ç¼.ÊÂÓÉID from dbo.LBsiT_¿Í·þ¼Ç¼ LEFT OUTER JOIN dbo.lbsit_¿Í»§ ON dbo.LBsiT_¿Í·þ¼Ç¼.¿Í»§±àÂë = dbo.lbsit_¿Í»§.¿¨ºÅ ORDER BY dbo.LBsiT_¿Í·þ¼Ç¼.¼Ç¼ʱ¼ä DESC Õâ¸öÊ
Ïà¹ØÎÊ´ð£º
import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class QueryTest&n ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý select ²¿ÃÅ,ÐÕÃû from tb ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ <folder state="unchecked" label="È«²¿"> ¡¡¡¡<folder state="unchecked" isBra ......
ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£ Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡ ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ js¿ØÖÆdivÏÔʾ/Òþ²ØÁË VS2008×Ô´ø·â×°Á ......
¸÷λ´óÏÀ£¬ÎÒѧϰµÄÊÇASP.NET£¬ÏëÖªµÀÏà¹Ø¼¼ÊõÓÐÄÄЩ£¬¾ÍÏñJAVA EEÖÐÓÐstruct sping jsp severlet µÈ£¬ASP.NET»¹ÓÐÄÄЩЩÏà¹Ø¼¼Êõ¡£ http://topic.csdn.net/u/20090914/21/af27de99-f0f3-4cfd-9379-13764f8ec6b1.ht ......