mysql> select * from (select * from students where name in (select name from students group by name having count(name)>1)) order by name desc;
ERROR 1248 (42000): Every derived table must have its own alias
请帮忙解决，新手上路
mysql 1248错误问题解决
答案:2 悬赏:40
解决时间 2021-03-10 00:17
- 提问者网友：傲气稳全场
- 2021-03-09 05:50
最佳答案
- 二级知识专家网友：高冷不撩人
- 2021-03-09 06:38
在from子句中的子查询需要起一个表的别名，做如下修改即可：
select * from (select * from students where name in (select name from students group by name having count(name)>1)) tmp order by name desc;
增加了子查询的别名tmp
select * from (select * from students where name in (select name from students group by name having count(name)>1)) tmp order by name desc;
增加了子查询的别名tmp
全部回答
- 1楼网友：寂寞的炫耀
- 2021-03-09 08:05
select min(maximum_salary)
from (
select dept_name, max(salary) maximum_salary
from instructor
group by dept_name
) tmp, 你必须给这个嵌套查询一个名字
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯