¥xÆW³Ì¤jµ{¦¡³]­pªÀ¸sºô¯¸
½u¤W¤H¼Æ
768
 
·|­ûÁ`¼Æ¡G245215
°Q½×¥DÃD¡G189089
Åwªï±z§K¶O¥[¤J·|­û
°Q½×°Ï¦Cªí >> MS SQL >> sql»yªk°ÝÃD
[]  
[§Ú­n¦^ÂÐ]
1
¦^À³¥DÃD ¥[¤J§ÚªºÃöª`¸ÜÃD ÀËÁ|¦¹½g°Q½× ±N´£°ÝªÌ¥[¤J­Ó¤H¶Â¦W³æ
sql»yªk°ÝÃD
»ù­È : 5 QP  ÂI¾\¼Æ:852 ¦^À³¼Æ:9

¼Ó¥D

520823
ªù¥~º~
0 6
77 12
µo°e¯¸¤º«H

®½ÃØ VP µ¹ 520823
½Ð°Ý§Ú¦³¥i¯à¹B¥Îorder by ©M dese ´N±N¸ê®Æ¿ý¼Æ¦rªº±Æ§Ç¥Ñ¤p¨ì¤j¡A¦A¥Ñ¤j¨ì¤p¡A¤@ª½¨ì³Ì«á¤@¦C¶Ü?
¨Ò¦p123 321 123 321......
ÁÙ¬O¦³¨ä¥L¤èªk?





·j´M¬ÛÃöTagsªº¤å³¹¡G [ sql»yªk ] ,
¥»½g¤å³¹µoªí©ó2016-04-13 20:10
§O§Ñ®½VP·PÁÂÀ°§U§Aªº¤H ·s¤â·|­ûÁ@¤@Á@
1¼Ó
³Ì¦³»ù­È¸Ñµª

P³¯
ÀËÁ|¦¹¦^À³
ÃD¥Ø¬Ý¨S???????????????????????????/
¥i¥H¦A¦h¶}¥Ü¤@ÂI¶Ü?


¾Ç®Õ§@·~¶Ü?
¥»½g¤å³¹¦^ÂЩó2016-04-13 20:25
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
2¼Ó
§@ªÌ¦^À³

520823
®½ÃØ VP µ¹ 520823 ÀËÁ|¦¹¦^À³
¬O¥\½Ò¨S¿ù
§Ú¦³25¦C¸ê®Æ,¨ä¤¤¸ê®Æ¦³5­Ó1,5­Ó2,5­Ó3,5­Ó4,5­Ó5,§Ú§Æ±æ±Æ§Çªº¤è¦¡¬O123455432112345543211234554321,
¦æ±o³q¶Ü?
¥»½g¤å³¹¦^ÂЩó2016-04-13 21:25
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
3¼Ó
¦^À³

P³¯
ÀËÁ|¦¹¦^À³
1.§ÚÁÙ¬O¬Ý¤£¥X§A­nªºÅÞ¿è
2.ùØ­±¦³ 6­Ó1¡A¤£¬O5­Ó1
3.¦Ñ®v¥Xªº³o­ÓÃD¥Ø¡A±z¦³¤°»ò¨S¥æ«Ý¨ì¶Ü?
¥»½g¤å³¹¦^ÂЩó2016-04-13 21:59
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
4¼Ó
¤£¿ùªº°Ñ¦Ò

±m­i
ÀËÁ|¦¹¦^À³
To P³¯:
§AÁÙ¯uªº¥h¼Æ¡C¡C¡C¶Ì²´
§@ªÌ¥u¬O¦h¥´¤F¤@¬q54321
Åܦ¨³£¬O¤»­Ó¡A¤£¬O¥u¦³1¦³¤»­Ó

To §@ªÌ¡G
³o¥\½Ò¯u©_§®¡A§A¥i¥H§¹¾ã§â»Ý¨D¦A´y­z¤@¹M¶Ü¡I¤£ª¾¹D¦Ñ®v¥X³oÃD¥Øªº¥Î·N¬O¤°»ò©O

¦pªG¥u¦³¤@­ÓÄæ¦ì¡A¥ú¬O¤U»¼¼W±Æ§Ç´N·|ÅÜ1111122222333334444455555
°£«DÃD¥Ø¥i¥H¦Û¦æ·s¼W¤@­ÓÄæ¦ì¥s°µ¡unumSort¡v¡A¨Ã¤À§Oµ¹¤©1~25ªº¼Æ­È±Æ§Ç
¤j­P¤W¬°³o¼Ë
Number numSort
1 1
2 2
3 3
4 4
5 5
5 6
4 7
3 8
2 9
1 10
. .
. .
¨Ì¦¹Ãþ±À
¥»½g¤å³¹¦^ÂЩó2016-04-13 23:03
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
5¼Ó
§@ªÌ¦^À³

520823
®½ÃØ VP µ¹ 520823 ÀËÁ|¦¹¦^À³
§Ú·QÀò±oªºª¾ÃѬO¡ASQL¦³¥Ñ¤p±Æ¨ì¤j(order by)¤Î¥Ñ¤j±Æ¨ì¤p(dese)ªº»yªk¡A
¨º¦³¨S¦³¥i¥Horder by ©M dese ¥æ¤¬¨Ï¥Îªº¤è¦¡¡A
1-5¦C¥Ñ¤p±Æ¨ì¤j¡A6-10¦C¥Ñ¤j±Æ¨ì¤p¡A11-15¦C¥Ñ¤p±Æ¨ì¤j¡A16-20¦C¥Ñ¤j±Æ¨ì¤p......
¥»½g¤å³¹¦^ÂЩó2016-04-13 23:08
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
6¼Ó
§@ªÌ¦^À³

520823
®½ÃØ VP µ¹ 520823 ÀËÁ|¦¹¦^À³
§Ú¦³¤@°ï1-nªº¼Æ¦r¡A
¨º§Ú§Æ±æ¸ê®Æ®w¥i¥HÀ°§Ú±Æ¥X
1-n, n-1,1-n,n-1...¤@ª½¨ì§â¼Æ¦r±Æ§¹¡A
¥»½g¤å³¹¦^ÂЩó2016-04-13 23:20
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
7¼Ó
§@ªÌ¦^À³

520823
®½ÃØ VP µ¹ 520823 ÀËÁ|¦¹¦^À³
¨Ò¦p¡G
name number
¨ß¤l 1
µU¤l 2
¨ß¤l 1
µU¤l 2
·à¤l 3
°¨ 4
·à¤l 3
°¨ 4


§Ú§Æ±æÅܦ¨
¨ß¤l 1
µU¤l 2
·à¤l 3
°¨ 4
°¨ 4
·à¤l 3
µU¤l 2
¨ß¤l 1

³æ¯Âsql+µ{¦¡¥i¦æ¶Ü?
ÁÙ¬O§Ú·s¶}­Ó¸ê®Æ®w¡A±q­ì¸ê®Æ®w¨ú¸ê®Æ¼g¤J¡A¨ººØ¤ñ¸û¥i¯à¦¨¥\?
¥»½g¤å³¹¦^ÂЩó2016-04-13 23:59
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
8¼Ó
¤£¿ùªº°Ñ¦Ò

¯uªº¦³ÂIÃø
ÀËÁ|¦¹¦^À³
1-5¦C¥Ñ¤p±Æ¨ì¤j¡A6-10¦C¥Ñ¤j±Æ¨ì¤p¡A11-15¦C¥Ñ¤p±Æ¨ì¤j¡A16-20¦C¥Ñ¤j±Æ¨ì¤p
¨º§A­n§â¸ê®Æ¦C¥ý½s¸¹
select id=identity(int,1,1),* into #temp from [dbo].[TB1]

create table #µ²ªG(Äæ¦ì int)

insert #µ²ªG
select ±Æ§ÇªºÄæ¦ì from #temp where id between 1 and 5 order by ±Æ§ÇªºÄæ¦ì

insert #µ²ªG
select ±Æ§ÇªºÄæ¦ì from #temp where id between 6 and 10 order by ±Æ§ÇªºÄæ¦ì desc


insert #µ²ªG
select ±Æ§ÇªºÄæ¦ì from #temp where id between 11 and 15 order by ±Æ§ÇªºÄæ¦ì

insert #µ²ªG
select ±Æ§ÇªºÄæ¦ì from #temp where id between 16 and 20 order by ±Æ§ÇªºÄæ¦ì desc

select * from #µ²ªG
¥»½g¤å³¹¦^ÂЩó2016-04-14 06:50
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
9¼Ó
§@ªÌ¦^À³

520823
®½ÃØ VP µ¹ 520823 ÀËÁ|¦¹¦^À³
¯uªº¦nÃø¡A¡A¡A¡A
¥»½g¤å³¹¦^ÂЩó2016-04-14 12:04
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
   
1

¦^ÂÐ
¦p­n¦^À³,½Ð¥ýµn¤J.