ÎÊ´ó¼ÒÒ»¸ösqlÓï¾ä,Ö÷×Ó±í²éѯ

Ö÷×Ó±í²éѯ, ²éѯÖ÷±íËùÓÐÊý¾ÝÇÒÖ»²éѯ×Ó±íij¸ö×ֶεÄ×îСֵ,·µ»Ø½á¹û

---

Ìṩ±í½á¹¹£¬²âÊÔÊý¾Ý£¬Ëã·¨ºÍÄãÒªµÄ½á¹û

---

- - | ÉñÈ˵ÄÌâÄ¿

---

ÒýÓÃ

Ìṩ±í½á¹¹£¬²âÊÔÊý¾Ý£¬Ëã·¨ºÍÄãÒªµÄ½á¹û

............

---

ÒýÓÃ

Ö÷×Ó±í²éѯ, ²éѯÖ÷±íËùÓÐÊý¾ÝÇÒÖ»²éѯ×Ó±íij¸ö×ֶεÄ×îСֵ,·µ»Ø½á¹û

ÏȶÔÁ˱íÕâ¸ö±í×Ö¶ÎÓú¯Êýmin²¢·Ö×éºóÓëÖ÷±í¹ØÁª

---

»òÊÇÓÃexists

ÐÎÈ磺
select *
from ta a
where not exists(select 1 from ta where colname = a.colname and colother < a.colother)

---

¹À¼Æ¾ÍÊÇ6Â¥ÄÇÑù

NND²»Òª¶ÌÁË°É

---

SELECT si.*,MIN(pi1.Balance) from SalesInfo si
 LEFT JOIN PayInfo pi1 ON si.SalesID=pi1.SalesID  
Ö÷±íSalesInfo ,×Ó±íPayInfo ,ÇóÖ÷±íËùÓÐÊý¾Ý,ÒѾ­¶ÔÓ¦µÄ×Ó±íBalance×Ö¶Î×îСֵ

Ö´Ðб¨´í
ÏûÏ¢ 8120£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 1 ÐÐ
Ñ¡ÔñÁбíÖеÄÁÐ 'SalesInfo.CustomerID' ÎÞЧ£¬ÒòΪ¸ÃÁÐûÓаüº¬ÔھۺϺ¯Êý»ò GROUP BY ×Ó¾äÖС£

¼ÓÁËGROUP BY ÎÞЧ

---

select a.* from a where a.id = (select min(id) from b)

---

×Ó±íÒª²éѯµÄÐÅÏ¢²»Êµ¹ØÁª×Ö¶Î

---

ÒѾ­½â¾ö,лл¸÷λ,É¢·Ö

 LEFT JOIN (SELECT pi1.SalesID, MIN(pi1.Balance) AS Balance from PayInfo pi1
GROUP BY pi1.SalesID) payInfo ON si.SalesID=payInfo.SalesID
°Ñ×Ó±íÐÅÏ¢ÏȲé³öÀ´,È»ºóͨ¹ý×ó¹ØÁª,²éѯpi1.BalanceµÄ×î´óÖµ

---