不知我这条是否正确,还请教比较好的!!!
select a.num,b.username from (select input_name,num = count(input_name) from news group by input_name) a ,(select username from adm_info) b where a.input_name = b.username
select a.num,b.username from (select input_name,num = count(input_name) from news group by input_name) a ,(select username from adm_info) b where a.input_name = b.username
解决方案 »
- 一个带子查询的查询优化问题
- sql语句不对!请高手帮忙!
- 这句mysql语句怎么排先后?
- 除去列中的数字,第一次发帖大家顶顶。
- 下面的函數為什麼執行時會出錯的?一直不明白.但里面的語句單獨拿出來卻是運行正确能返回結果的.
- 我有一个VB编的学生信息管理程序,是书中的一例子,数据库是用Microsoft SQL service2000,程序运行不起来
- 这种合并的语句怎么写?谢谢!
- 我知道SQLSERVER能进行LDAP通讯,请问各位,它能提供LDAP服务?做成一个LDAP服务器吗?
- 小妹很需要帮忙,能否腾出一只手?关于pb的问题
- 哪位大虾能提供一个例子:用DTS import a text file into a table.我可以用dts设计器手动做,但是编程怎么做?
- jdbc 如何调用 sql server 的带输出cursor参数的存储过程?
- !请教,关于整型和字符串
from news a
left join adm_info b on b.username=a.input_name
group by a.input_name,b.Position
from news a
join adm_info b on b.username=a.input_name
group by a.input_name,b.Position
from news as a,adm_info as b
where a.input_name=b.UserName
group by a.input_name,b.Position
from news a,adm_imfo b
where a.input_name=b.username
group by input_name,position
select a.input_name,num = count(a.input_name),b.user_Position
from news a
left join adm_info b on b.username=a.input_name
group by a.input_name,b.user_Position
go
select a.input_name,a.num,b.user_Position from (select input_name,num = count(input_name) from news group by input_name) a ,
(select username,user_Position from adm_info) b
where a.input_name = b.username
go
select a.input_name,num = count(a.input_name),b.user_Position
from news a
join adm_info b on b.username=a.input_name
group by a.input_name,b.user_Positiongo
select a.num,b.username,b.user_position from (select input_name,num = count(input_name) from news group by input_name) a ,(select username,user_position from adm_info) b where a.input_name = b.username
from t1,t2
where t1.input_name=t2.username
group by input_name,position
后面的问题不知道答案,关注中................