Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ServerÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ

Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Äã¶¼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâÆªÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾­Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......

SQL Serverµ¼³ö±íµ½EXCELÎļþµÄ´æ´¢¹ý³Ì


SQL Serverµ¼³ö±íµ½EXCELÎļþµÄ´æ´¢¹ý³Ì
 
·¢²¼Ê±¼ä£º2008.07.11 09:00     À´Ô´£ºÈüµÏÍø    ×÷ÕߣºÐ¡ÇÇ
¡¾ÈüµÏÍø£­IT¼¼Êõ±¨µÀ¡¿SQL Serverµ¼³ö±íµ½EXCELÎļþµÄ´æ´¢¹ý³Ì:
*--Êý¾Ýµ¼³öEXCEL
 
µ¼³ö±íÖеÄÊý¾Ýµ½Excel,°üº¬×Ö¶ÎÃû,ÎļþÎªÕæÕýµÄExcelÎļþ
,Èç¹ ......

SQL_²éѯµ±Ìì¡¢½ü¼¸Ìì¡¢±¾ÖÜ¡¢±¾ÔµÄSQLÓï¾ä

¾­³£»áÓÐʱºòÒªÓõ½²éѯµ±Ì죬½ü¼¸Ì죬±¾ÖÜ£¬±¾ÔµÄÏà¹ØÊý¾Ý£¬ËùÒԼǼһÏÂÕâЩ±È½ÏÌØÊâµÄSQLÓï¾ä~~
--µ±Ìì
(usrRegTime >=CONVERT(varchar(10),getDate(),120)+' 00:00:00' and usrRegTime <=CONVERT(varchar (10),getDate(),120)+' 23:59:59')
--½üÈýÌì
DateDiff(day,usrRegTime,getdate()) <=3
--±¾ÖÜ ......

SQLÓï¾ä¸´ÖƱíµÄ·½·¨


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].[ ......

ÎÄ˼´´ÐµÄSQL±ÊÊÔÌâ


ÌâÄ¿£ºÓÐAºÍBÁ©¸ö±í£¬¶¼¶¨ÒåÏàͬµÄÖ÷¼ü£¬Ð´³öSQLÓï¾äÕÒ³öA±íÖÐÓжøB±íÖÐûÓеļǼ£¬È»ºó°ÑûÓеļǼ²åÈëµ½B±íÖС£
SQLÓï¾äÈçÏ£º
CREATE TABLE  A_MINUS_B  AS              ---´´½¨Ò»¸ö²î¼¯±íA_MINUS_B ,×¢ÒâSELECT Óï¾äÒ»¶¨ÒªA±íÔÚǰ¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ