SQLÖÐÆæ¹ÖµÄÅÅÐòÎÊÌâ

ÎÒÓÐÒ»¸ö±í£¬Ò»¸öÊÓͼÁ¬½ÓÆðÀ´

ÎÒÊǸù¾Ý±íÖеĻý·Ö×Ö¶ÎÅÅÐòµÄ£¬µ«ÊÇÈç¹ûÎÒд³ÉÕâÑù
SQL code:

SELECT TOP(10) U.UserID
from V_Employee E
LEFT JOIN V_UserInfo U ON E.UserID = U.UserID
WHERE U.UserName LIKE '%%'
AND U.TrueName LIKE '%%'
ORDER BY U.store DESC


²éѯ³öÀ´µÄ½á¹ûÊÇÕâÑù
userid
--------
120
241
4
5
6


µ«ÊÇÎÒд³ÉÕâÑù
SQL code:

SELECT TOP(5) U.*
from V_Employee E
LEFT JOIN V_UserInfo U ON E.UserID = U.UserID
WHERE U.UserName LIKE '%%'
AND U.TrueName LIKE '%%'
ORDER BY U.store DESC



²éѯµÄÄÚÈÝÊÇÕâÑùµÄ
userid  username        truename  department                store
-------------------------------------------------------------------
120 chenyong  ³ÂÓÀ ×ۺϲ¿                 20
241 dwchenwen ³ÂÎÈ ¼¼Êõ²¿                 12
1536 qiumeng         ÇñÃÎ °ËÏçÕò·þÓªÌü£¨×ÔÓª£©      0
1903 yuzhi         ÓàÖ¾ °Ë