Sql²éÕÒ×îÐÂÈÕÆÚ - .NET¼¼Êõ / ASP.NET

ÈçºÎÓÃsqlÓï¾ä²éѯ³ö×îÐÂÈÕÆÚËùÔÚÁеÄËùÓÐÊý¾ÝÄØ£¿

---

ÓÃorder by¾Í¿ÉÒÔʵÏÖ

---

order by ÈÕÆÚ desc

---

top 1 + order by

---

SQL code:
select * from t_data where f_date =(select max(f_date) from t_data)

---

order by

---

Â¥Ö÷£¬°Ñ±í½á¹¹·¢³öÀ´°¡£¡

---

select * from ±íÃû order by ÈÕÆÚ×ֶΠdesc

---

select top 1,* from table where F_date=(select max(F_date) from table)

---

ͬÒâÒÔÉϻش𣡣¡

---

ÒýÓÃ

SQL code
select * from t_data where f_date =(select max(f_date) from t_data)

UP~

---

all crrency

---

Â¥Ö÷µÄÎÊÌâ û¸ã¶®°¡

---

order by desc ½µÐò
 Ä¬ÈÏ asc ÉýÐò

---

select * from Tb where Ìõ¼þ order by ÈÕÆÚ desc

---

ÈçºÎÓÃsqlÓï¾ä²éѯ³ö×îÐÂÈÕÆÚËùÔÚÁеÄËùÓÐÊý¾ÝÄØ£¿
----------------------------------------------
×îÐÂÈÕÆÚËùÔÚÁеÄËùÓÐÊý¾Ý£¿ ÈÕÆÚÁеÄÊý¾Ý£¿