sql 如何嵌套查询

发布网友 发布时间：2023-08-06 00:29

我来回答

共5个回答

热心网友 时间：2024-10-02 13:44

select a.username,numa,numb
from (select username,count(username) as numa from a where isdel=0 group by username order by numa desc) a,
(select username,count(username) as numb from a where isdel=0 and isx=1 group by username) b
where a.username = b.username

热心网友 时间：2024-10-02 13:47

java里面要实现sql嵌套查询的话,如果是javaweb项目,是可以使用hibernate框架提供的直接执行sql语句的方式来实现这样的功能.

热心网友 时间：2024-10-02 13:48

select id,name,department表.department_name from user ,department表 where department_id = department表.id

热心网友 时间：2024-10-02 13:44

select username,count(username)over(partition by username order by numa desc)
from a
where isdel=0 and isx=1

不知是不是这个意思？

热心网友 时间：2024-10-02 13:47

select username,count(username) as numa from a where isdel=0 group by username order by numa desc

union

select username,count(username) as numb from a where isdel=0 and isx=1 group by username