sql²éѯѡÔñ±íÖдÓ10µ½15µÄ¼Ç¼
ORDER BY ×Ӿ䰴һÁлò¶àÁУ¨×î¶à 8,060 ¸ö×Ö½Ú£©¶Ô²éѯ½á¹û½øÐÐÅÅÐò¡£ÓÐ¹Ø ORDER BY ×Ó¾ä×î´ó´óСµÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ ORDER BY ×Ó¾ä (Transact-SQL)¡£
Microsoft SQL Server 2005 ÔÊÐíÔÚ from ×Ó¾äÖÐÖ¸¶¨¶Ô SELECT ÁбíÖÐδָ¶¨µÄ±íÖеÄÁнøÐÐÅÅÐò¡£ORDER BY ×Ó¾äÖÐÒýÓõÄÁÐÃû±ØÐëÃ÷È·µØ¶ÔÓ¦ÓÚ SELECT ÁбíÖеÄÁлò from ×Ó¾äÖеıíÖеÄÁС£Èç¹ûÁÐÃûÒÑÔÚ SELECT ÁбíÖÐÓÐÁ˱ðÃû£¬Ôò ORDER BY ×Ó¾äÖÐÖ»ÄÜʹÓñðÃû¡£Í¬Ñù£¬Èç¹û±íÃûÒÑÔÚ from ×Ó¾äÖÐÓÐÁ˱ðÃû£¬Ôò ORDER BY ×Ó¾äÖÐÖ»ÄÜʹÓñðÃûÀ´ÏÞ¶¨ËüÃǵÄÁС£
ÅÅÐò¿ÉÒÔÊÇÉýÐòµÄ (ASC)£¬Ò²¿ÉÒÔÊǽµÐòµÄ (DESC)¡£Èç¹ûδָ¶¨ÊÇÉýÐò»¹ÊǽµÐò£¬¾Í¼Ù¶¨Îª ASC¡£
SELECT
[USER_ID],[USER_NAME],[USER_EMAIL],[USER_PASSWORD]
from users where [USER_EMAIL] is not null and [USER_PASSWORD] is not null
--˵Ã÷£ºÑ¡Ôñ´Ó11µ½15µÄ¼Ç¼
select top 5
[USER_ID],[USER_NAME],[USER_EMAIL],[USER_PASSWORD]
from (select top 15 [USER_ID],[USER_NAME],[USER_EMAIL],[USER_PASSWORD] from users
order by [USER_ID] asc) users2
where [USER_EMAIL] is not null and [USER_PASSWORD] is not null order by [USER_ID] desc
ÉÏÊöÓï¾ä
(select top 15 [USER_ID],[USER_NAME],[USER_EMAIL],[USER_PASSWORD] from users
order by [USER_ID] asc) users2
±íʾ½«Ç°Êý¾Ý¿âµÄǰ15Ìõ¼Ç¼°´ÄæÐòÅÅÁУ¬´æ·ÅÔÚ±ðÃûΪuser2µÄ±íÖС£
È»ºóÔÙͨ¹ý
select top 5
À´Ñ¡³öǰ5Ìõ¼Ç¼£¬ÒòΪuser2Êǰ´ÄæÐòÅÅÁеģ¬ËùÒÔ×îºó½á¹ûÊÇ´ÓµÚ15-11ÌõµÄ¼Ç¼¡£
¸üÐÂ
Èçϲéѯ´úÂëËùʾ£¬ÎÒÃÇ¿ÉÒÔ¿´µ½ÓÐÒ»ÐеÄwhere±»×¢ÊÍÁË£¬ÕâÊÇÒòΪÔÚÈ«ÃæµÄ²éѯ¼¯ÖÐÒѾȥµôÁ˲»·ûºÏÒªÇóµÄÄÚÈÝÁË£¬ºóÃæ¾Í²»ÐèÒªÔÙÓÃwhereÀ´ÏÞ¶¨¡£´úÂë×¢ÊÍ»¹¸ø³öÁËÊ×Ä©ÊýµÄ¼ÆËã·½·¨¡£
--µÚ¶þ¸öÊý-µÚÒ»¸öÊý+1¿ªÊ¼£¬µ½µÚ¶þ¸öÊýλÖÃ
--´Ó7001¿ªÊ¼£¬µ½11828Ϊֹ¡£µÃ³öµÚÒ»¸öÊý£¬11828-x+1=7001,x=4828
SELECT top 4828
'<User>'+
'<Username>' + [USER_NAME] + '</Username>',
'<Email>' + [USER_EMAIL] + '</Email>',
'<Password>' + [USER_PASSWORD] + '</Password>' +
'</User>'
from (select top 11828 [USER_ID],[USER_NAME],[USER_EMAIL],[USER_PASSWORD] from users
where [USER_EMAIL] is not nul
Ïà¹ØÎĵµ£º
Ò»¡¢sqlÊéд¹æ·¶£º
1¡¢sqlÓï¾äµÄËùÓбíÃû¡¢×Ö¶ÎÃûÈ«²¿Ð¡Ð´£¬ÏµÍ³±£Áô×Ö¡¢ÄÚÖú¯ÊýÃû¡¢sql±£Áô×Ö´óд¡£
2¡¢Á¬½Ó·ûor¡¢in¡¢and¡¢ÒÔ¼°£½¡¢<=¡¢>=µÈǰºó¼ÓÉÏÒ»¸ö¿Õ¸ñ¡£
3¡¢¶Ô½ÏΪ¸´ÔÓµÄsqlÓï¾ä¼ÓÉÏ×¢ÊÍ£¬ËµÃ÷Ëã·¨¡¢¹¦ÄÜ¡£
&nb ......
VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó×ܽá
ͨ¹ýÉÏÆªÎÄÕ£¨http://www.cnblogs.com/user34j/archive/2007/01/23/628426.html£©µÄÉèÖÃÆäʵÒѾ²î²»¶àÍê³ÉÁË£¬Ö»ÊÇ»¹ÓÐһЩϸ½ÚµÄµØ·½Ã»ÓÐ×öºÃ£¬¾¹ýÒ»·¬Ñо¿ÏÖÔÚÖÕÓڸ㶨ÁË¡£¶ÔÓÚÏñÎÒÕâÑùµÄÐÂÊÖÀ´Ëµ£¬Õû¸öÊý¾Ý¿âÁ¬½ÓÕæÊDz»ÈÝÒס£ÏÖ×ܽáÈçÏ£ ......
SQL Serverµ¼³ö±íµ½EXCELÎļþµÄ´æ´¢¹ý³Ì
·¢²¼Ê±¼ä£º2008.07.11 09:00 À´Ô´£ºÈüµÏÍø ×÷ÕߣºÐ¡ÇÇ
¡¾ÈüµÏÍø£IT¼¼Êõ±¨µÀ¡¿SQL Serverµ¼³ö±íµ½EXCELÎļþµÄ´æ´¢¹ý³Ì:
*--Êý¾Ýµ¼³öEXCEL
µ¼³ö±íÖеÄÊý¾Ýµ½Excel,°üº¬×Ö¶ÎÃû,ÎļþÎªÕæÕýµÄExcelÎļþ
,Èç¹ ......
SQLÓï¾ä¸´ÖƱíµÄ·½·¨
(2009-08-29 13:41:54)
±êÇ©£º
sql
·ÖÀࣺ¼ÆËã»ú֪ʶ
Èç¹ûÄ¿µÄ±íÒѾ´æÔÚ:
insert into DATAHR.DBO.GBITEM
select * from DEMO.DBO.GBITEM
Èç¹ûÄ¿µÄ±í²»´æÔÚ:
select * into DATAHR.DBO.GBITEM
from DEMO.DBO.GBITEM
¿ç¿âµ¼Èë
select * into [zk_news].[dbo].[News1] from [zk_media].[ ......