SQLÎĵÄÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

select kes.k from  
(SELECT acct.KesKigo+acct.KesNo as ak from acct) as a,
(SELECT count(acct.KesKigo+acct.KesNo) as k from acct, fd_user where acct.ActNo = fd_user.ActNo 
 group by acct.KesKigo+acct.KesNo) as kes
where kes.k = a.ak

Õâ¸öSQL´íÔÚÄÄÄØ
Ö´Ðб¨µÄ´íÊÇ£º構ÎÄ´íÎó¡£値 '0G1blB9K9-' ²»ÄÜ´Óvarchar ת»»µ½ int ¥Çー¥¿ÐÍ

KesKigo varchar
KesNo varchar

---

SQL code:
select kes.k from
(SELECT acct.KesKigo+ltrim(acct.KesNo) as ak from acct) as a,
(SELECT count(acct.KesKigo+ltrim(acct.KesNo)) as k from acct, fd_user where acct.ActNo = fd_user.ActNo
group by acct.KesKigo+ltrim(acct.KesNo)) as kes
where kes.k = a.ak

---

値 '0G1blB9K9-' ²»ÄÜ´Óvarchar ת»»µ½ int ¥Çー¥¿ÐÍ

---

ÎÒÏëÎʵÄÊÇÔõô¸Ä

---

ÒýÓÃ

ÎÒÏëÎʵÄÊÇÔõô¸Ä

°ÑÊýÖµµÄÊý¾ÝÀàÐÍתΪVARCHAR¾Í¿ÉÒÔÁË¡£

---

select kes.k from  
(SELECT acct.KesKigo+acct.KesNo as ak from acct) as a,
(SELECT count(acct.KesKigo+acct.KesNo) as k from acct, fd_user where acct.ActNo = fd_user.ActNo  
 group by acct.KesKigo+acct.KesNo) as kes
where kes.k = a.ak

akÊÇ×Ö·û,
count(acct.KesKigo+acct.KesNo) as k 
ÕâÀïÊÇINT,ÄÜÏàµÈ???????

---

select kes.k from  
(SELECT acct.K