一道面试题:sql语句问题 一个worker表,有Sid,name,rating(级别),age(年龄)四个字段,求平均年龄最小的那个级别? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Select top1 rating From worker Group by rating order by avg(age) desc select rating,min(avg(age)) from worker group by rating select * from worker where rating= (select top 1 rating from worker group by rating order by avg(age)) select top 1 rating from worker group by rating order by avg(age) Select top 1 rating From worker Group by rating order by avg(age) select top1 rating from worker group by rating order by avg(age) do熊 SQL codeSelect top 1 rating From worker Group by rating order by avg(age) select top1 rating from worker group by rating order by avg(age) select top 1 rating from worker group by rating order by avg(age) sql中的外键约束问题 怎么做这个报表? sql 2005 如何建立索引 触发器监控UPDATE的时候,如何得到每一行的修改前数据? 请教一个sql语句?????????????/ 求此SQL优化方法 SQLserver 建立作业 请问sql2005中存储过程里“每当 sql 启动时执行”的选项在哪? 请问根据一个(多个)字段倒排序的sql语句?及时结帖 ER/Sutdio问题:欢迎高手进门!!! 多表关联查询的问题 这两天学习,遇到一系列的问题,帮忙回答下
select *
from worker
where rating=
(select top 1 rating from worker group by rating order by avg(age))