查询a表的最后一次添加的数据
select a.*
from a a,(select t.userid id, max(t.timer) ti
from (select *
from tablename
where createtime between to_date('2018-04-01', 'yyyy-mm-dd') and
to_date('2018-04-30', 'yyyy-mm-dd')) t --查出2018-04-01的所有数据
group by id) y --根据t.userid分组查询最大的日期
where a.userid = y.id
and a.timer = y.ti
现有表student(id name)subject(id sname) score(id sid score) 查询 id 为3的学生的name ,课程名sname,成绩score,成绩的等级
select stu.id, stu.name, sub.sname, lev.score, lev.等级
from student stu,
subject sub,
(select s.id id,
s.sid sid,
s.score score,
case
when score >= 80 then
'优'
when score >= 70 and score <= 80 then
'良'
when 60 < score and score < 70 then
'及格'
else
'不及格'
end 等级
from score s) lev
where stu.id = lev.id
and sub.sid = lev.sid
and stu.id = 3