SQLÓï¾ä - MS-SQL Server / »ù´¡Àà

²éѯ×îÐÂ10ÌõÊý¾Ý£¬Ê±¼ä°´ÉýÐòÅÅÁУ¬Èô²»¹»10Ìõ£¬ÏÔʾ´æÔÚµÄÊý¾Ý

---

SQL code:
select top 10 * from [Table] order by ʱ¼ä desc

---

ÎÒÏ밴ʱ¼äÉýÐòÅÅÁÐ

---

select top 10 * from [Table] order by ʱ¼ä

---

3Â¥Àí½â´íÎó
ÎÒµÄÒâ˼²éѯ³ö×îºó10ÌõÊý¾Ýºó£¬È»ºóÔÙ°´Ê±¼äÈÃËüÏÔʾ

---

Χ¹Û£¡

---

û¿´¶®Ê²Ã´Òâ˼

---

SQL code:
select * from (select top 10 * from [Table] order by ʱ¼ä desc) aa order by ʱ¼ä

---

7Â¥¿´¶®ÁË
6Â¥£¬ÔÛÃǵÄÃû×ÖÒ»Ñù°¡ÏÂÃæ

---

ѧϰһÏ¡£¡£¡£

---

select * from (select top 10 * from [Table] order by ʱ¼ä desc) aa order by ʱ¼ä