![]() ![]() ![]() ![]() |
|||||
|
|||||
¼Ó¥D 520823 ![]()
![]() ![]() |
¨Ò¦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 ![]() ![]() |
¬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¼Ó |
1.§ÚÁÙ¬O¬Ý¤£¥X§AnªºÅÞ¿è
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¼Ó
¤£¿ùªº°Ñ¦Ò
±mi ![]() |
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´yz¤@¹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ªº¼ÆÈ±Æ§Ç ¤jP¤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 ![]() ![]() |
§Ú·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 ![]() ![]() |
§Ú¦³¤@°ï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 ![]() ![]() |
¨Ò¦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
¨º§An§â¸ê®Æ¦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 ![]() ![]() |
¯uªº¦nÃø¡A¡A¡A¡A
¥»½g¤å³¹¦^ÂЩó2016-04-14 12:04
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
¦^ÂÐ |
¦pn¦^À³,½Ð¥ýµn¤J. |